$ ./guess_the_languageSQL & Databases
SQL & Databases · easy · #1

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;
  1. Ann
  2. Bob
  3. Cat
  4. No row
Sorted descending the salaries are 300, 200, 100; OFFSET 1 skips Bob, so LIMIT 1 returns Cat.
Play SQL & Databases ▸