order by with conditions

[praveenhotha]

Hi

I would like to sort a list of numbers in descending order but if the value is 0, they should appear at the beginning of the list. How can I implement this in query.

 

Thanks in advance.

 

 

[bh]

Hi,

 

its a bit tricky. I tried to implement the order by what you said. I figured out that you can use an expression in your ORDER BY clause.

With the expression you can do the DESC order with 0s coming to first.

 

Heres the query. I hope it helps.

SELECT number FROM temptable
ORDER BY number=0 DESC, number DESC;