how to write a sql like this ? [message #372903] |
Fri, 16 March 2001 13:28 |
Oranewbie
Messages: 2 Registered: March 2001
|
Junior Member |
|
|
select title,'classification'=CASE
When price<10 then 'low'
When price>20 then 'High'
else 'normal'
end
from titles
this sql can run at sql server 7.0,how to write a sql like this in oralce 7.3?
please help me
|
|
|
|
Re: how to write a sql like this ? [message #372910 is a reply to message #372903] |
Fri, 16 March 2001 21:11 |
balu
Messages: 23 Registered: March 2001
|
Junior Member |
|
|
Hi,
you can do this in oracle 8i. The format is
select sal,case when sal<1000
then 'sal is less than 1000'
else 'sal is more than 1000'
end from emp;
try this in 8i, but it won't work in 7.3.
If you want do this function use decode in 7.3
select sal, decode(abs(sal-1001),sal-1001,'Sal is greater than 1000','Sal is less than or equal to 1000');
With Regards,
Balu
|
|
|