How to order by with union?

Question

Is it possible to order when the data is come from many select and union it 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

To apply an Order By clause in a Union Query, you need to follow these simple steps:

1. Write your first SELECT statement, and include the Order By clause in it.
2. Write your second SELECT statement, and include the Order By clause in it.
3. Combine the two SELECT statements using the Union or Union All clause, placing them inside parentheses.
4. Add the Order By clause at the end of the entire query.

The syntax for applying Order By clause in a Union Query is:

(SELECT column1, column2, …FROM table1ORDER BY column1 ASC)UNION(SELECT column1, column2, …FROM table2ORDER BY column1 DESC)ORDER BY column1 ASC;

The above query will return the combined results of the two SELECT statements, sorted by column1 in ascending order.

Answer 2

you may order by position like...order by 2.