This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Which of the following best describes the use of DISTINCT with a function as in SUM(DISTINCT )? ... (Read 90 times)

BRWH

  • Hero Member
  • *****
  • Posts: 553
on: Jul 7, 2018
Which of the following best describes the use of DISTINCT with a function as in SUM(DISTINCT )?
 
  A) Only distinct values are totaled, repeated values are ignored
  B) It only sums one row at a time
  C) It has no effect
  D) None of the above

Question 2

Query by example uses a series of keywords and commands to select the rows and columns for a query.
 
  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

hanadaa

  • Sr. Member
  • ****
  • Posts: 339
Reply #1 on: Jul 7, 2018
Answer to Question 1

A

Answer to Question 2

FALSE


BRWH

  • Member
  • Posts: 553
Reply 2 on: Jul 7, 2018
Gracias!

nathang24

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

« previous next »
 

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

Did you know?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

Most fungi that pathogenically affect humans live in soil. If a person is not healthy, has an open wound, or is immunocompromised, a fungal infection can be very aggressive.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

Pulmonary function test: spirometry. (a) Normal respiratory volumes, as measured during spirometry. Pulmonary function test: spirometry. (a) Normal respiratory volumes, as measured during spirometry.
Overview of protein structure and function Overview of protein structure and function
How to sketch a cubic function using transformations How to sketch a cubic function using transformations
Histone and pol II CTD modifications as a function of gene position Histone and pol II CTD modifications as a function of gene position
How B Vitamins Function as Coenzymes (c) How B Vitamins Function as Coenzymes (c)
Thyroid Function Thyroid Function
Video: Structure of Amino Acid, Peptide Bonds & Polypeptides

For a complete list of videos, visit our video library