decode in order by clause with desc
282792Feb 17 2003 — edited Jun 26 2008I want to user order by clause with decode + desc order.
somthing like
ORDER BY DECODE ('SALE', e.sale, 'SALE DESC' ????)
????-> How to use desc order with decode
Thanks in advance