Which keyword is used to retain duplicate rows in the query output
Answers
Answered by
3
"EXPLANATION" :--- The keyword 'ALL' usedalong with 'UNION' is not synonymous with just the 'UNION' statement. It produces the duplicate rows, if they exist, from the combination of the two tables in the SELECT query.
Answered by
0
The keyword ‘ALL’ used along with ‘UNION’ is not synonymous with just the ‘UNION’ statement. It produces the duplicate rows, if they exist, from the combination of the two tables in the SELECT query.
Similar questions