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

ghepp

  • Member
  • Posts: 361
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Thyroid conditions may make getting pregnant impossible.

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?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

There are over 65,000 known species of protozoa. About 10,000 species are parasitic.

Flower part number is a characteristic difference between monocots and eudicots Flower part number is a characteristic difference between monocots and eudicots
Large size can provide a refuge from predators. While young African elephants may be vulnerable to p Large size can provide a refuge from predators. While young African elephants may be vulnerable to p
Overview of protein structure and function Overview of protein structure and function
Skilled nursing facilities provide care for patients requiring longer stays than hospitals allow. Skilled nursing facilities provide care for patients requiring longer stays than hospitals allow.
How to apply integration by parts on a single function How to apply integration by parts on a single function
How to vertically stretch and compress the quadratic function How to vertically stretch and compress the quadratic function
Video: Subunits of DNA And Semi Conservative Replication

For a complete list of videos, visit our video library