MCQOPTIONS
Home
About Us
Contact Us
Bookmark
Saved Bookmarks
Testing Subject
General Aptitude
Logical and Verbal Reasoning
English Skills Ability
Technical Programming
Current Affairs
General Knowledge
Finance & Accounting
GATE (Mechanical Engineering)
Chemical Engineering
→
Structured Query Language (SQL)
→
Status Variables
→
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
Your experience on this site will be improved by allowing cookies. Read
Cookie Policy
Reject
Allow cookies