Re: SQL Question

[Adam Glauser <adamglauser@xxxxxxxxxxxx>]

Jeff Young wrote:
> Given the following SQL Statement -
> select substr(oncitm,5,10) cstitm, onitem,okpric    price,          
> case when okpgrp = '40004' then '1'                                 
>     when okpgrp = '40001' then '2' end case                         
>  from                                                               
> vcoitem join vinitem                                                
>
> How can I specify the result of the CASE clause in the order by clause.
> Also, how can I assign a name to the result of the CASE clause 

As far as I know, you have to copy the whole case statement into the 
ORDER BY clause, like so

 select substr(oncitm,5,10) cstitm, onitem,okpric    price,
 case when okpgrp = '40004' then '1'
     when okpgrp = '40001' then '2' end case
  from
 vcoitem join vinitem
 order by case when okpgrp = '40004' then '1' 

     when okpgrp = '40001' then '2' end case