SQLzoo.net

Get the 11th to the 20th rows of the cia table - by population.

SQL Server
	SELECT TOP 10 x.name, x.population FROM ( SELECT TOP 20 name, population FROM cia ORDER BY population DESC) x ORDER BY x.population ASC
Specific to SQL Server
We select the bottom 10 of the top 20 - we end up with the list in the wrong order - this can be fixed with another nested select.