Use three columns in Order by clause

Question

I am using three columns while sorting the table using an order by clause. First column is sorted by ascending order and other two columns are sorted by descending order. In my case all three columns have to sort by ascending order.

Can you please give me solution for this?

The official [docs](https://learn.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql?view=sql-server-ver15) should always be your first point of reference. — Dale K, Feb 28 '20 at 05:01

score 0 · Answer 1 · answered Feb 28 '20 at 04:55

0

You can include as many fields as you want in the ORDER BY clause:

SELECT a, b, c FROM the_table ORDER BY a ASC, b ASC, c ASC;

answered Feb 28 '20 at 04:55

Daniel McLaury

4,047
1
15
37

In what way is it not working? – Daniel McLaury Feb 28 '20 at 05:07
So you're saying you get the record (1, 2, 2) before (2, 1, 1)? That sounds right, since you're sorting by RIU_reportDisplayNumber first. – Daniel McLaury Feb 28 '20 at 05:18
It's not an exact duplicate.. I recommend leaving this open – Saravanan Mar 20 '20 at 07:26

Use three columns in Order by clause

1 Answers1