Create and execute a SQL command to display the names of all languages. Limit it to the top 10.

SELECT *
LIMIT 10;

Do it again, limiting it to rows 21-25.

SELECT * FROM CountryLanguage LIMIT 21,5;

Create and execute a SQL command to display the names of all languages that for which "IsOffical" is true. Limit to first 10.

SELECT * FROM CountryLanguage WHERE IsOfficial = 'T' LIMIT 10;

List ALL distinct government types.

SELECT DISTINCT GovernmentForm FROM Country

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