Re: if then else statement on 2 columns in SQL query?

SELECT DECODE(..)
FROM xxx
ORDER BY DECODE(y.column,'ORANGES',1,'PEARS',2,'APPLES',3,'GRAPE',4, 'PEACHES',5, 6) knez wrote:
>
> After decoding apples, pears, oranges, peaches, grapes - what can be done to
> get them into a specific order (not alpha). {oranges, pears, apples, grape,
> peaches?}
Received on Tue Oct 20 1998 - 01:25:51 CDT