select query

[RK2003]

Hi All,
Can any one help me for getting a SQL for this condition.
TABLE
column A column B column C column D,columnE
VALUE1
VALUE2
VALUE3

I am selecting columnA,columnB,columnC from TABLE.
I need query to get select like
if the value is VALUE2 then this select must take columnA,column, D,columnE else columnA,columnB,columnC

Thanks

[PAVB]

Please post a DESC of your table, solution might depend on datatypes.

[RK2003]

Table is
TABLE
Name Type
---------------
colA VARCHAR2(25)
colB VARCHAR2(15)
colC DATE
colD DATE
colE DATE
colF DATEn

If colA is other than VALUE1 then
select colA,colB,colC from
if ColA is VALUE2 then
select colA,colD,colE from table

hope this is clear

[RK2003]

Table is
TABLE
Name Type
---------------
colA VARCHAR2(25)
colB VARCHAR2(15)
colC DATE
colD DATE
colE DATE
colF DATE

If colA is other than VALUE2 then
select colA,colC,colD from
if ColA is VALUE2 then
select colA,colE,colF from table

hope this is clear

[PAVB]

Okay... piece of cake.

I'm not doing your job but I'll point you in the right direction, here is the hint.

Use UNION statement.
First select should return colA, colC and colD when colA != VALUE2.
Second select should return colA, colE and colF when colA = VALUE2.

Now show us your best effort.

[xeric]

Hi,

You may do it with a single pass throught select like this :

select colA, (case when colA = VALUE2 then colE else colC end) x_name,
(case when colA = VALUE2 then colF else colD end) y_name
from table

if your DBMS is not Oracle you can find a substitution to case when. For SQL SERVER use IIF

Best Regards