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

SGallaher96 · **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

cassie_ragen · **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