SQL Editor

SQL Order By Multi Column Example

Task:

List all customers ordered by country, then by city within each country.
Click here for details on Order By.
 
 91 Records
FirstName LastName City Country
Patricio Simpson Buenos Aires Argentina
Yvonne Moncada Buenos Aires Argentina
Sergio Gutiérrez Buenos Aires Argentina
Roland Mendel Graz Austria
Georg Pipps Salzburg Austria
Catherine Dewey Bruxelles Belgium
Pascale Cartrain Charleroi Belgium
André Fonseca Campinas Brazil
Paula Parente Resende Brazil
Mario Pontes Rio de Janeiro Brazil
Bernardo Batista Rio de Janeiro Brazil
Janete Limeira Rio de Janeiro Brazil
Lúcia Carvalho Sao Paulo Brazil
Aria Cruz Sao Paulo Brazil
Pedro Afonso Sao Paulo Brazil
Anabela Domingues Sao Paulo Brazil
Jean Fresnière Montréal Canada
Elizabeth Lincoln Tsawassen Canada
Yoshi Tannamuri Vancouver Canada
Palle Ibsen Århus Denmark
Jytte Petersen Kobenhavn Denmark
Matti Karttunen Helsinki Finland
Pirkko Koskitalo Oulu Finland
Martine Rancé Lille France
Mary Saveley Lyon France
Laurence Lebihan Marseille France
Janine Labrune Nantes France
Carine Schmitt Nantes France
Marie Bertrand Paris France
Dominique Perrier Paris France
Paul Henriot Reims France
Frédérique Citeaux Strasbourg France
Annette Roulet Toulouse France
Daniel Tonini Versailles France
Sven Ottlieb Aachen Germany
Maria Anders Berlin Germany
Philip Cramer Brandenburg Germany
Horst Kloss Cunewalde Germany
Renate Messner Frankfurt a.M. Germany
Henriette Pfalzheim Köln Germany
Alexander Feuer Leipzig Germany
Hanna Moos Mannheim Germany
Peter Franken München Germany
Karin Josephs Münster Germany
Rita Müller Stuttgart Germany
Patricia McKenna Cork Ireland
Giovanni Rovelli Bergamo Italy
Maurizio Moroni Reggio Emilia Italy
Paolo Accorti Torino Italy
Ana Trujillo México D.F. Mexico
Antonio Moreno México D.F. Mexico
Francisco Chang México D.F. Mexico
Guillermo Fernández México D.F. Mexico
Miguel Angel Paolino México D.F. Mexico
Jonas Bergulfsen Stavern Norway
Zbyszek Piestrzeniewicz Warszawa Poland
Isabel de Castro Lisboa Portugal
Lino Rodriguez Lisboa Portugal
Eduardo Saavedra Barcelona Spain
Diego Roel Madrid Spain
Martín Sommer Madrid Spain
Alejandra Camino Madrid Spain
José Pedro Freyre Sevilla Spain
Maria Larsson Bräcke Sweden
Christina Berglund Luleå Sweden
Yang Wang Bern Switzerland
Michael Holz Genève Switzerland
Helen Bennett Cowes UK
Simon Crowther London UK
Victoria Ashworth London UK
Elizabeth Brown London UK
Thomas Hardy London UK
Ann Devon London UK
Hari Kumar London UK
Paula Wilson Albuquerque USA
Rene Phillips Anchorage USA
Jose Pavarotti Boise USA
Liu Wong Butte USA
Yoshi Latimer Elgin USA
Howard Snyder Eugene USA
Helvetius Nagy Kirkland USA
Art Braunschweiger Lander USA
Liz Nixon Portland USA
Fran Wilson Portland USA
Jaime Yorres San Francisco USA
Karl Jablonski Seattle USA
John Steel Walla Walla USA
Carlos González Barquisimeto Venezuela
Manuel Pereira Caracas Venezuela
Felipe Izquierdo I. de Margarita Venezuela
Carlos Hernández San Cristóbal Venezuela
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.