CODEWITHSUNDEEP
sqlpostgresql
Abdalla Ismail
Abdalla Ismail

Reputation: 409

Sql sort by query

I have an Sql query that is the union of three queries, for example : 

 query1 
 Union 
 query2 
 Union 
 query3

I want to ask if there is a way to have the output respective by queries , such that the results of query1 are first in the ResultSet , query2 second and query3 at then end.

Thank you

Upvotes: 1

Views: 66

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269793

You would normally do this by including a column specifying the query and ordering by that:

select . . .
from ((select q.*, 1 as ordering from (<query1>) q) union all
      (select q.*, 2 as ordering from (<query2>) q) union all
      (select q.*, 3 as ordering from (<query3>) q)
     ) q
order by ordering;

Note: This replaces the union with union all, so duplicates are not removed.

Upvotes: 4

Related Questions