A Gentle Introduction to

SQL

META DATA

Information about the database: what tables exist, what are the column headings, what database is in use.


Get the 11th to the 20th rows of the cia table - by population.
oracle variations:
This seems very complicated, seemingly the rownum is calculated after the WHERE clause runs so WHERE rownum>1 always gives zero rows.

access
db2
mysql
oracle
postgres
sqlserver