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 82 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
Great answer, keep it coming :)

dyrone

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

The horizontal fraction bar was introduced by the Arabs.

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

Did you know?

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

Did you know?

Coca-Cola originally used coca leaves and caffeine from the African kola nut. It was advertised as a therapeutic agent and "pickerupper." Eventually, its formulation was changed, and the coca leaves were removed because of the effects of regulation on cocaine-related products.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Structure and function of the Na+/K+ pump. Structure and function of the Na+/K+ pump.
The difference between AZT-sensitive versus AZT-resistant reverse transcriptases The difference between AZT-sensitive versus AZT-resistant reverse transcriptases
Reaction velocity as a function of substrate concentration Reaction velocity as a function of substrate concentration
How to vertically shift a quadratic function along the y-axis How to vertically shift a quadratic function along the y-axis
Reciprocal function Reciprocal function
Algebraically determine the x intercept of the exponential function Algebraically determine the x intercept of the exponential function
Video: The Hypothalamus: The Body's Thermostat (Human Thermostat)

For a complete list of videos, visit our video library