sorting by value specific - ORDER BY
I am开发者_C百科 trying to sort a query using ORDER BY where I need to sort 3 columns one by one. And the third column is value specific.
Eg: If i have 3 columns a,b and c I need to use ORDER BY a, b desc, c='3' asc, c
What I want to do is first sort order is a, then b in desc order then I want the values of which has 3 to be sorted and then the remaining values which are not 3.
ORDER BY
a,
b desc,
CASE WHEN c = 3 THEN 0 ELSE 1 END,
c
Assuming SQL Server, try using CASE:
ORDER BY a, b desc, CASE c WHEN '3' THEN 0 ELSE 1 END, c ASC
ORDER BY
a,
b desc,
CASE c when 3 then 1 else 0 end
精彩评论