Sql sort by query
<p>I have an Sql query that is the union of three queries, for example : </p>

<pre><code> query1 
 Union 
 query2 
 Union 
 query3 
</code></pre>

<p>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.</p>

<p>Thank you</p>