SQL Union sort by Union

Question

I have query

SELECT id, name 
  FROM users 
  WHERE id !=2 
UNION 
SELECT id, name 
  FROM users2 
  WHERE id != 3;

I want that sort will be, 1 union orders + 2 union it's possible ?

bobthedeveloper · Accepted Answer · 2014-04-20 10:27:41Z

2

Add a column to order on

SELECT id, name, 1 as unionOrder FROM users WHERE id !=2 
UNION 
SELECT id, name, 2 as unionOrder FROM users2 WHERE id != 3

ORDER BY unionOrder

answered Apr 20, 2014 at 10:27

bobthedeveloper

3,7832 gold badges16 silver badges31 bronze badges

2

+1. You may also find it's more efficient to use union all to avoid potential duplicate removal where duplicates probably cannot exists (eg, if id is unique key).
– paxdiablo
Commented Apr 20, 2014 at 10:31

Add a comment |

Rahul · Accepted Answer · 2014-04-20 11:40:02Z

1

You can as well do like

(SELECT id, name 
  FROM users 
  WHERE id !=2
ORDER BY id)
UNION ALL
(SELECT id, name 
  FROM users2 
  WHERE id != 3
  ORDER BY id);

answered Apr 20, 2014 at 11:40

Rahul

77.8k14 gold badges77 silver badges129 bronze badges

Add a comment |

2 Answers 2