double sort -- sort of -- in sql

Question

I have a database. It has two columns. Let's say one colum is "Country" and the other column is "City".

Now, one can query the database and have the query end with "order by Country" and the output will be such that the rows are sorted alphabetically by Country.

But what if I wanted them to be primarily sorted by country name and then with the rows for each country, the output is sorted secondarily by city name. How would that query look like?

as a test, I have opened sql server and at the end of the select top 1000 query I added "order by country" and there was no syntax error. But if I add "order by Country order by City", it does not like it. Adding a comma does nto help. Adding "and" does not help either.

Andomar · Accepted Answer · 2011-06-13 16:28:42Z

9

You can order on multiple columns by separating them with a comma:

order by Country, City

answered Jun 13, 2011 at 16:28

Andomar

239k55 gold badges387 silver badges412 bronze badges

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

1 Comment

DavidO Over a year ago

You may also specify direction on a per-column basis. For example: 'ORDER BY Country, City DESC

devdigital · Accepted Answer · 2011-06-13 16:28:55Z

5

Try the following

Order By Country, City

answered Jun 13, 2011 at 16:28

devdigital

34.4k9 gold badges102 silver badges122 bronze badges

Comments

Steve Prentice · Accepted Answer · 2011-06-13 16:29:15Z

5

You can specify more than one column to order by. Just separate them with a ,.

SELECT * FROM my_table ORDER BY Country, City;

answered Jun 13, 2011 at 16:29

Steve Prentice

23.6k11 gold badges56 silver badges56 bronze badges

Comments

user532231 · Accepted Answer · 2011-06-13 16:29:59Z

4

It's enough to separate them by a comma ,

SELECT * FROM Table ORDER BY Country, City

answered Jun 13, 2011 at 16:29

user532231

Collectives™ on Stack Overflow

double sort -- sort of -- in sql

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related