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 75 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 :)

sailorcrescent

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

« previous next »
 

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

Patients should never assume they are being given the appropriate drugs. They should make sure they know which drugs are being prescribed, and always double-check that the drugs received match the prescription.

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

Parkinson's disease is both chronic and progressive. This means that it persists over a long period of time and that its symptoms grow worse over time.

Did you know?

The oldest recorded age was 122. Madame Jeanne Calment was born in France in 1875 and died in 1997. She was a vegetarian and loved olive oil, port wine, and chocolate.

Dugongs (a) adjust their foraging behaviour as a function of whether or not tiger sharks (b) are hun Dugongs (a) adjust their foraging behaviour as a function of whether or not tiger sharks (b) are hun
The difference between mieosis and mitoses The difference between mieosis and mitoses
Encephalization is a function of both brain size and body size. Encephalization is a function of both brain size and body size.
Please provide me with a solution for part b. Please provide me with a solution for part b.
How to write a composite function f(g(x)) and g(f(x)) (Part 2) How to write a composite function f(g(x)) and g(f(x)) (Part 2)
How to approximate the area of a function using midpoints How to approximate the area of a function using midpoints
Video: Carpal Tunnel Syndrome

For a complete list of videos, visit our video library