OraFAQ Forum: Forms » SQL query

Home » Developer & Programmer » Forms » SQL query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL query [message #84410]

Thu, 11 March 2004 18:01

amit goel
Messages: 20
Registered: March 2004

Junior Member

There is a emp table having name and salary columns.

I want to write a sql statement which shows name and bonus columns in which if salary>2500 then salary+1000
or if salary<2500 then salary+500

Please help.What would be the query?

Report message to a moderator

Re: SQL query [message #84414 is a reply to message #84410]

Thu, 11 March 2004 22:22

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Example:

SQL> SELECT ename, sal, CASE WHEN sal > 2500 THEN sal + 1000
  2                          WHEN sal < 2500 THEN sal + 500
  3                     END as Bonus
  4  FROM emp
  5  /

ENAME             SAL      BONUS
---------- ---------- ----------
SMITH             800       1300
ALLEN            1600       2100
WARD             1250       1750
JONES            2975       3975

Best regards.

Frank

Report message to a moderator

Previous Topic:	Forms level errors and DB level errors
Next Topic:	Close button

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 11:41:37 CDT 2024