RE: SQL QUERY HELP

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 05 Apr 2001 11:12:23 -0700
Message-ID: <F001.002E2FE3.20010405110127@fatcity.com>

> -----Original Message-----
> From: Seema Singh [mailto:oracledbam_at_hotmail.com]
>
> 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 Received on Thu Apr 05 2001 - 13:12:23 CDT