Skip to main content
B
bimbica
Participating Frequently
May 4, 2006
Answered

How to make double Order by???

  • May 4, 2006
  • 1 reply
  • 660 views
I'm beginner with cold fusion...if someone could help me...

From a table with two fields City and Country I want to obtain an interrogation with two ordering: first ordered Country and then City. Can I make it in one query?

An example shoud be:

COUNTRY CITY
America Chicago
America New York
France Paris
Italia Milano
Italia Modena
Italia Roma

Thank you a lot!
bye
This topic has been closed for replies.
Correct answer Dan_Bracuk
order by country, city

1 reply

D
Dan_BracukCorrect answer
Inspiring
May 4, 2006
order by country, city
B
bimbicaAuthor
Participating Frequently
May 5, 2006
Ok thank you I'll try to do so. But I've thought another way to do it, with group by country and order by city. If I want more than two ordered columns, will it work?
B
bimbicaAuthor
Participating Frequently
May 5, 2006

It works with more than two fields: for example ORDER BY Country, Language, City...and so on.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices