Re: order by desc - with zeros on top

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