This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Explain briefly the difference between a scalar function and an aggregate function. Provide ... (Read 47 times)

SGallaher96

  • Hero Member
  • *****
  • Posts: 509
on: Jul 7, 2018
Explain briefly the difference between a scalar function and an aggregate function. Provide examples.
 
  What will be an ideal response?

Question 2

Data structures are usually described using a binary notation.
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

cassie_ragen

  • Sr. Member
  • ****
  • Posts: 347
Reply #1 on: Jul 7, 2018
Answer to Question 1

Scalar functions operate on each record individually. An example is the MONTH function that extracts the integer for the current month from a date. When used, this function extracts the month for every record in the query. Aggregate functions work on sets of records. The Sum function, for instance, totals all the records in a set and returns a single value.

Answer to Question 2

FALSE


SGallaher96

  • Member
  • Posts: 509
Reply 2 on: Jul 7, 2018
Wow, this really help

shailee

  • Member
  • Posts: 392
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Did you know?

Approximately one in three babies in the United States is now delivered by cesarean section. The number of cesarean sections in the United States has risen 46% since 1996.

Did you know?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

Function and structure of aquaporin Function and structure of aquaporin
The function of a ligand-gated ion channel The function of a ligand-gated ion channel
Overview of protein structure and function Overview of protein structure and function
How to combine and sketch transformations of a sinusoidal function (Question 1) (y=a*sin⁡b(x−c)+d) How to combine and sketch transformations of a sinusoidal function (Question 1) (y=a*sin⁡b(x−c)+d)
Exponential Function vs. Power Function Exponential Function vs. Power Function
Social scientists have not done well at devising theories to explain lovely romantic moments Social scientists have not done well at devising theories to explain lovely romantic moments
Video: Simple Diffusion - Ion transport

For a complete list of videos, visit our video library