Get the 11th to the 20th rows of the cia table - by population.
Jump to navigation
Jump to search
Get the 11th to the 20th rows of the bbc table - by population.
SELECT name, population FROM bbc
ORDER BY population DESC LIMIT 10 OFFSET 10
SELECT TOP 10 x.name, x.population FROM (
SELECT TOP 20 name, population FROM bbc
ORDER BY population DESC) x
ORDER BY x.population ASC
SELECT name, population FROM bbc
ORDER BY population DESC LIMIT 10 OFFSET 10
SELECT name, population FROM (
SELECT name, population, rownum n FROM (
SELECT name,population FROM bbc
ORDER BY population DESC)
)
WHERE n BETWEEN 11 AND 20
SELECT TOP 10 x.name, x.population FROM (
SELECT TOP 20 name, population FROM bbc
ORDER BY population DESC) x
ORDER BY x.population ASC
SELECT * FROM bbc
ORDER BY population DESC
LIMIT 11, 10
Your server today is: Dipsy