Re: field alias for case function

select decode (id, 1, 9, id) as id from temp_t1;

what SQL-dialect is the original statement written in?

Best regards,
Erik
"sy" <sychen_at_vidmon.com> wrote in message news:44dec6fa.0305011017.5f6efbc_at_posting.google.com...
> Hi,
>
> How do I give a field alias for the following sql statement:
>
> select case id when 1 then 9 else id end case from temp_t1;
>
> I would to give a field name for the output.
>
> Thanks
> sy
Received on Thu May 01 2003 - 13:47:38 CDT