Answers for "To combine the result-set of two or more SELECT statements, SQL clause used is"

Combines the results from 2 or more SELECT statements and returns only
distinct values.
Example: Returns the cities from the events and subscribers tables.
SELECT city FROM events
UNION
SELECT city from subscribers;

Posted by: Guest on January-07-2021

what is union in sql

UNION:
COMBINES THE RESULT OF 2 QUERY AND
REMOVES DUPLICATE ROWS AND
SORTS BY FIRST COLUMN

Posted by: Guest on January-07-2021

Code answers related to "To combine the result-set of two or more SELECT statements, SQL clause used is"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "To combine the result-set of two or more SELECT statements, SQL clause used is"

Code answers related to "To combine the result-set of two or more SELECT statements, SQL clause used is"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "To combine the result-set of two or more SELECT statements, SQL clause used is"

Code answers related to "To combine the result-set of two or more SELECT statements, SQL clause used is"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us