way to solve

[ilikesuresh]

Hi i have the table called table_days
based on the case result i need to select either d0 or d1

i have written this query to do it
But this will give missing expression error
Plz give me a way to accomplish my task

select name,
case when (trunc(sysdate) - trunc(update_date) = 2)
then
select d0 from table_days
end
from table_days

[holdingbe]

Hi i have the table called table_days
based on the case result i need to select either d0 or d1

i have written this query to do it
But this will give missing expression error
Plz give me a way to accomplish my task

select name,
case when (trunc(sysdate) - trunc(update_date) = 2)
then
select d0 from table_days
end
from table_days

Hi friend
pls correct query

select
case when trunc(sysdate) - trunc(update_date) = 2 then (SELECT 'd0' FROM TABLE_DAYS) ELSE '1'end
from table_days;

[amitpatel66]

Hi friend
pls correct query

select
case when trunc(sysdate) - trunc(update_date) = 2 then (SELECT 'd0' FROM TABLE_DAYS) ELSE '1'end
from table_days;

The above Query would return 'd0' as a value and not column value. And it is not mandatory to write SELECT for each CASE statement in case if the column that is returned is from same table itself. You can directly say the column name itself as shown below:

SELECT
CASE WHEN Empno = 112 THEN ename
ELSE
TO_CHAR(empno) END
from emp
 

Note: ELSE clause is Optional

[ilikesuresh]

Hi friend
pls correct query

select
case when trunc(sysdate) - trunc(update_date) = 2 then (SELECT 'd0' FROM TABLE_DAYS) ELSE '1'end
from table_days;

Thanks buddy.
but this d0 is a column name in the table_days

[amitpatel66]

Thanks buddy.
but this d0 is a column name in the table_days

Do post back in case of any further issues!!