Case statement

[ak99]

i need to display when code=10 then delqdays has to be greater than 30 else dont display

I used
select * from abc WHERE DelqDays >=( CASE WHEN IN (10) THEN '30' END )

Plz help

[Krandor]

i need to display when code=10 then delqdays has to be greater than 30 else dont display

I used
select * from abc WHERE DelqDays >=( CASE WHEN IN (10) THEN '30' END )

Plz help

select * from abc WHERE  DelqDays >= 30 AND code =10

[ak99]

select * from abc WHERE  DelqDays >= 30 AND code =10

Thanks for your help
I think there is some misunderstanding,,it does not have filter on anything but except when code=10,,so it diplays everything when code is something else besides 10 but when code=10,,then delqdays has to be equal or greater than 30.

[gk53]

try that
select * from abc WHERE 'Y' = case
when code = 10 then case when delqdays =>30 then
else 'N' end
else 'Y' end

[annaharris]

You can make nested case where

SELECT CASE WHEN code = 10 THEN delqdays =>30

else "N" end