How to order by with union

Question

Is it possible to order when the data comes from many select and union them together? Such as

Select id,name,age

From Student

Where age < 15

Union

Select id,name,age

From Student

Where Name like "%a%"

How can I order this query by name?

Some said you can query look like this.

Select id,name,age

From Student

Where age < 15 or name like "%a%"

Order by name

But in this case, I just ignore that solution.

Thank you in advance.

Answer 1

You can try below code:

Select id,name,age

From Student

Where age < 15

Union

Select id,name,age

From Student

Where Name like "%a%"

Order by name

Note: The order by clause will be applied to the complete resultset