Order by -- different sequence for different criteria

Question

I want to do something like this:
select a
from table
order by
 case when a='A' then b,c,d
 else d,c,b

a, b, c, d are all columns of the the table.

GMB · Answer

Your question is not that clear about the result that you really expect, bu I suspect that is:
order by
    case when a = 'A' then b else d end,
    c,
    case when a = 'A' then d else b end

Or if you want records where a = 'A' first (with the specified order), and then the rest of the records (with the other sequence), then:
order by
    case when a = 'A' then 0 else 1 end,
    case when a = 'A' then b else d end,
    c,
    case when a = 'A' then d else b end

Order by -- different sequence for different criteria

One Answer

Add your own answers!

Ask a Question