Hi Gurus,



Can any one please tell me how put the following condition in a CASE
statement.




If all "some_Id" is Y, then A,

else if any some_Id is Y, then B.

else C



where "some_Id" is a column and A, B and C are the target values that I
want to populate based on the given condition above.





Thanks & Regards,

SK

Oracle LazyDBA home page