> -----Original Message-----
> From: Seema Singh [mailto:[EMAIL PROTECTED]]
>
> I have following data in table emp
> empcode empname SAL
> a001 XXXXX 2000
> b001 YYYYY 4000
> c001 AAAAA 5000
> d001 CCCCC 8000
> If sal is >=5000 there will be another columns grade and
> print A else B
> The outout would be like
> empcode empname SAL Grade
> a001 XXXXX 2000 B
> b001 YYYYY 4000 B
> c001 AAAAA 5000 A
> d001 CCCCC 8000 A
> Please help how can i write such query.
SQL> select sal, decode (sign (sal - 5000), 0, 'A', 1, 'A', 'B') as grade
2 from t ;
SAL G
---------- -
4000 B
5000 A
6000 A
------
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com
