ALL retains duplicate rows in result of query or in aggregate expression - SQL Operations

Q.  Which of the following retains duplicate rows in the result of a query or in an aggregate expression?
- Published on 08 Jul 15

a. ALL
b. DISTINCT
c. PRIOR
d. None of the above

ANSWER: ALL
 
The ALL compares one value to every other value in the list and is TRUE if all the comparisons are true.

Related Content

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲