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 76 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
Gracias!

phuda

  • Member
  • Posts: 348
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

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?

Anti-aging claims should not ever be believed. There is no supplement, medication, or any other substance that has been proven to slow or stop the aging process.

Brain mass as a function of body mass in mammals. Brain mass as a function of body mass in mammals.
Proximal tubule function Proximal tubule function
Model for translocon function Model for translocon function
There Is a Difference between Natural and Added Sugars There Is a Difference between Natural and Added Sugars
State the transformations on the function f(x)= 4sin(x-pi)-2 and then graph two cycles below. State the transformations on the function f(x)= 4sin(x-pi)-2 and then graph two cycles below.
Gene products that are essential to mitochondrial function Gene products that are essential to mitochondrial function
Video: Introduction to Insulin

For a complete list of videos, visit our video library