Thread
:
Case statement in Where
View Single Post
#
5
(
permalink
)
February 13th, 2012, 04:24 AM
akaas.website
Registered User
Points: 30, Level: 1
Activity: 0%
Join Date: May 2011
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
try this:
SELECT DATA
FROM TABLE
WHERE
1 = (
CASE
WHEN date1 = date2 THEN
CASE
WHEN date3 > date4 THEN 1
ELSE 0
END
ELSE
CASE
WHEN date1 > date2 THEN 1
ELSE 0
END
END
)
Regards,
Akaas Developer
http://www.questions-interviews.com/...es/oracle.aspx
akaas.website
View Public Profile
Visit akaas.website's homepage!
Find all posts by akaas.website