• List the countries sorted asending by region name.
SELECT Name,Region FROM Country ORDER BY Region

  • List the countries sorted descending by GNP.
SELECT Name, GNP FROM Country ORDER BY GNP DESC;

  • List the countries sorted asending first by region, then by GNP.
SELECT Name, Region, GNP FROM Country ORDER BY Region, GNP DESC;
Topic revision: r1 - 2013-10-21 - JimSkon
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback