MCQOPTIONS
Bookmark
Saved Bookmarks
→
Structured Query Language (SQL)
→
Status Variables in Structured Query Language (SQL)
→
Which keyword used with UNION does not retain dupl..
1.
Which keyword used with UNION does not retain duplicate rows?
A.
ALL
B.
NARROW
C.
STRICT
D.
DISTINCT
Answer» C. STRICT
Show Answer
Discussion
No Comment Found
Post Comment
Related MCQs
SELECT on a MERGE table is like _____________
Which table is used to run a UNION-type query on MyISAM tables?
Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this?
Which clause is used to sort a UNION result as a whole?
The UNION ALL has a higher precedence than UNION DISTINCT.
The following SQL statement is invalid.
WHICH_CLAUSE_IS_USED_TO_SORT_A_UNION_RESULT_AS_A_WHOLE??$
Suppose_it_is_desired_that_UNION_operation_should_return_not_more_than_3_rows._Which_keyword_is_used_for_this?$
The UNION ALL has a higher precedence than UNION DISTINCT?
Which keyword used with UNION retains duplicate rows?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply