Skip to content
Advertisement

CASE Statement for Order By Clause with Multiple Columns and Desc/Asc Sort

Following on from my earlier question here Case statement for Order By clause with Desc/Asc sort I have a statement like this:

This works well, but sometimes I need more than column in the order by. I actually need something like this:

I can’t work out how to make the CASE statement allow multiple columns in the THEN part.

Advertisement

Answer

Do you need this?

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement