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 105 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
Wow, this really help

TheNamesImani

  • Member
  • Posts: 334
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Did you know?

It is important to read food labels and choose foods with low cholesterol and saturated trans fat. You should limit saturated fat to no higher than 6% of daily calories.

Did you know?

The FDA recognizes 118 routes of administration.

Antiparkinson Drugs Focus on Restoring Dopamine Function and Blocking Cholinergic Activity in the ... Antiparkinson Drugs Focus on Restoring Dopamine Function and Blocking Cholinergic Activity in the ...
How to evaluate trigonometric functions when theta is an inverse trigonometric function How to evaluate trigonometric functions when theta is an inverse trigonometric function
How to evaluate and sketch a piecewise function containing absolutes (Part 2) How to evaluate and sketch a piecewise function containing absolutes (Part 2)
Look at the graph function shown belowPlea Look at the graph function shown belowPlea
Structure and function of the gills of a bony fish. Structure and function of the gills of a bony fish.
Use of forward and reverse genetics to determine gene function Use of forward and reverse genetics to determine gene function
Video: Exercise and cardiac output & Definition of stroke volume

For a complete list of videos, visit our video library