How to use order by in union query in SQL?

Question

Can anyone explain how to use order by in union query in SQL?

Answer 1

Here is the syntax to use ORDER BY clause along with UNION operator in a query:

SELECT column1, column2,……column

FROM table_name

WHERE condition

UNION

SELECT column1, column2,……column

FROM table_name

WHERE condition

ORDER BY column_name;

In the above SQL query, the ORDER BY clause will be applied to the complete result set.

If you want to learn SQL from Industry experts, I suggest this SQL Certification course by Intellipaat that provides Instructor-led training, hands-on experience, and certification.