-
SQL CASE statement with Multiple THEN's
I am wondering whether its possible to extract two seperate columns of data after a 'THEN' statement when using CASE
For example
Select country,
CASE WHEN X>1 Then (code which allows 'A' in one column and 'B' in a second column)...........
END
FROM TABLE_A
Can't find anything in my 9i query books. Is there a way?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|