ben bernier’s badass blog

i wanted to use this:

(select * from Seasons where id=5) union
(select * from Seasons where id<>5 order by id desc);

but i had to use this:

SELECT * FROM
(SELECT * FROM Seasons
WHERE id=5
ORDER BY id DESC) AS t1

UNION

SELECT * FROM
(SELECT * FROM Seasons
WHERE id<>5
ORDER BY id desc) AS t2