How To Use ORDER BY with UNION Operators in MS SQL Server?

Question

Amit Singh · Answer

If you need to sort the output from two queries grouped together with a UNION operator, you need to apply the ORDER BY clause at the group level, not at the subquery level.
for example:
(SELECT * FROM sample WHERE tag = 'MCA' ORDER BY created)
UNION
(SELECT * FROM sample WHERE tag = 'BCA' ORDER BY created)

interview

How To Use ORDER BY with UNION Operators in MS SQL Server?

Can you answer this question?

1 Answers