On Jun 14, 2006, at 0:29 , Christoph Frick wrote:
> IIRC there where recently a sql code snippet, that solved the
> problem of
> "ordering a list of ints descending - but keep the zero on top":
SELECT shown_production_id
FROM wherever
ORDER BY shown_production_id = 0
, shown_production_id desc;
I don't remember if TRUE sorts before FALSE, but either use = 0 or <>
0. That should work.
Michael Glaesemann
grzm seespotcode net