How to sort a table by multiple columns using SQL Server?

Question

I have an unsorted Table A.

C1    C2    C3      C4
----------------------    
15      2     7      5
12      5     4      8
19      1     3     12
21      9     1     18
 4     11    12     22

I want to sort this table in such a way that values with higher c1, higher c4, higher c2 and lower c3 are on top.

Also, c1 > c2 > c4 > c3 in terms of priority.

I am not sure how to go about this and would really appreciate any help from experts here.

Should I assign a fraction value to each column like c1 = .35 , c2 = .3, c4 = .2, and c3 = .15 and multiply the value for each column by its fraction value and add up all the values for each row?

What have you tried so far? Please have a look on "ORDER BY". This should be quite easy... — Gottfried Lesigang
– Gottfried Lesigang, Commented Jul 14, 2015 at 13:30
Why would 12 5 4 8 come before 15 2 7 5 ? Without a full explanation of the logic, no one can help you. — Tab Alleman
– Tab Alleman, Commented Jul 14, 2015 at 13:39

Tab Alleman · Accepted Answer · 2015-07-14 13:38:48Z

1

Sounds like you need:

ORDER BY C1 DESC, C2 DESC, C4 DESC, C3 ASC

answered Jul 14, 2015 at 13:38

Tab Alleman

31.8k7 gold badges41 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user4622594 · Accepted Answer · 2015-07-14 13:39:42Z

0

You mean simple order by? Then just add an order byclause:

ORDER BY C1 DESC, C4 DESC, C2 DESC, C3 ASC

DESC = descending, from highest to lowest .ASC = ascending, from lowest to highest

answered Jul 14, 2015 at 13:39

user4622594

Collectives™ on Stack Overflow

How to sort a table by multiple columns using SQL Server?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related