Union Select und ORDER BY

[omata]

SQL-Code:

SELECT 1 typ, nr, ...
FROM tabelle
WHERE ds > 1000
  AND flag <> 1

UNION 

SELECT 2 typ, nr, ...
FROM tabelle
WHERE ds <= 1000
  AND flag <> 1

UNION

SELECT 3 typ, nr, ...
FROM tabelle
WHERE flag = 1

ORDER BY typ, nr