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 89 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
:D TYSM

tranoy

  • Member
  • Posts: 344
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Anesthesia awareness is a potentially disturbing adverse effect wherein patients who have been paralyzed with muscle relaxants may awaken. They may be aware of their surroundings but unable to communicate or move. Neurologic monitoring equipment that helps to more closely check the patient's anesthesia stages is now available to avoid the occurrence of anesthesia awareness.

Did you know?

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

Did you know?

A serious new warning has been established for pregnant women against taking ACE inhibitors during pregnancy. In the study, the risk of major birth defects in children whose mothers took ACE inhibitors during the first trimester was nearly three times higher than in children whose mothers didn't take ACE inhibitors. Physicians can prescribe alternative medications for pregnant women who have symptoms of high blood pressure.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Hematuria. An analysis of urine is performed to evaluate kidney function. In this illustration, the Hematuria. An analysis of urine is performed to evaluate kidney function. In this illustration, the
Distribution of Aggregate Mining Distribution of Aggregate Mining
Difference between chromosomes, chromatids, and chromatins Difference between chromosomes, chromatids, and chromatins
Farmers’ markets provide fresh, local produce to consumers Farmers’ markets provide fresh, local produce to consumers
Use the graph of the function f(x) to answer each question. Use the graph of the function f(x) to answer each question.
Sheridan Motors is a car dealership that would like to investigate if there is a difference in ... Sheridan Motors is a car dealership that would like to investigate if there is a difference in ...
Video: Dorsal Recumbent Position

For a complete list of videos, visit our video library