Which name does this query return?
-- emp(name, salary): ('Ann',100), ('Bob',300), ('Cat',200)
SELECT name FROM emp
ORDER BY salary DESC
LIMIT 1 OFFSET 1;
- Ann
- Bob
- Cat
- No row
Sorted descending the salaries are 300, 200, 100;
Play SQL & Databases ▸
OFFSET 1 skips Bob, so LIMIT 1 returns Cat.