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 29 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
Thanks for the timely response, appreciate it

lkanara2

  • Member
  • Posts: 329
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Blood in the urine can be a sign of a kidney stone, glomerulonephritis, or other kidney problems.

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Negative control of a repressible set of genes: function of the trp repressor and corepressor in reg Negative control of a repressible set of genes: function of the trp repressor and corepressor in reg
The effects of aging can be seen in the decline in function of many physiological systems. The effects of aging can be seen in the decline in function of many physiological systems.
How to approximate the area of a function using midpoints How to approximate the area of a function using midpoints
How to vertically shift a sinusoidal function (y=a*sin⁡b(x−c)+d) How to vertically shift a sinusoidal function (y=a*sin⁡b(x−c)+d)
Testing motor function of cranial nerve VII - Smile Testing motor function of cranial nerve VII - Smile
What's the Difference Between England, Great Britain, and United Kingdom? What's the Difference Between England, Great Britain, and United Kingdom?
Video: Glycolysis - and oxygen

For a complete list of videos, visit our video library