Posted By

andyhartleeds on 11/06/07


mysql database select sql order UNION BY ordering

Versions (?)

Who likes this?

1 person have marked this snippet as a favorite


Ordering multiple SELECT statements in a UNION

 / Published in: SQL

  1. (SELECT a FROM t1 WHERE a=10 AND B=1)
  2. UNION
  3. (SELECT a FROM t2 WHERE a=11 AND B=2)
  4. ORDER BY a LIMIT 10;

Report this snippet  

You need to login to post a comment.