Order by a first column and then order by a second one

Question

I have a table like this:

Age | Points
-------
22  | 5000   
15  | 100
22  | 45
14  | 50
13  | 10
12  | 500
11  | 356
15  | 25

And I like a result like this (first I order table by age and then for each age I order by points):

Age | Points
-------
22  | 5000 
22  | 45
15  | 100
15  | 25
14  | 50
13  | 10
12  | 500
11  | 356

How can I do it through SQL?

Dupicate: http://stackoverflow.com/questions/2051162/sql-multiple-column-ordering — Nordine, Jul 05 '16 at 10:51

score 2 · Answer 1 · answered Jul 05 '16 at 10:47

2

select * from your_table
order by age desc, points desc

answered Jul 05 '16 at 10:47

juergen d

score 1 · Answer 2 · answered Jul 05 '16 at 10:48

1

select * 
from TableName
order by Age desc, Points desc

answered Jul 05 '16 at 10:48

Flea777

I solved it. I wrote "Points desc, Age desc" that's why I didn't get the expected result – kirito100floors Jul 05 '16 at 10:54
@kirito100floors You didn't write anything – Strawberry Jul 05 '16 at 11:02

score 0 · Answer 3 · answered Jul 05 '16 at 10:48

0

use order by clause

select * from TABLE 
order by age ,points desc

answered Jul 05 '16 at 10:48

Mahesh Madushanka

score 0 · Answer 4 · answered Jul 05 '16 at 11:09

0

select * 
from TableName
order by Age desc, Points desc

answered Jul 05 '16 at 11:09

Asif patel

Code-only answers are considered poor-quality content on Stack Overflow. Please provide information about why this answers the question. Copying another answer verbatim is considered very poor form, and without any kind of commentary, this looks very bad. – Michael Gaskill Jul 05 '16 at 15:16

4 Answers4