OraFAQ Forum: SQL & PL/SQL » Re: sql help for(3 condition st)

Home » SQL & PL/SQL » SQL & PL/SQL » Re: sql help for(3 condition st)

Fri, 05 April 2002 03:44

Thierry Van der Auwera
Messages: 44
Registered: January 2000

Member

Hi,

Depending on your Oracle Version :

SELECT CASE
WHEN sal < 5000 THEN 'Low'
WHEN sal > 10000 THEN 'Hi'
ELSE 'Ok'
END AS aaa
FROM ...

Previous Topic:	3 million records
Next Topic:	A free SQL server to query

Goto Forum:

]

Current Time: Wed Apr 24 23:10:09 CDT 2024