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

BRWH · **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