Pick columns, sort, limit in SQL

SQL interview exercise on Select & Filter, difficulty 1 of 3. Solve it in the editor beside a worked example, or cold in Interview mode with the example hidden; the tests run the moment you do.

Return the three cheapest products. Columns: name, price. Cheapest first; when two prices are equal, sort those by name.

Each exercise pairs a worked example with a twin problem to solve in a real editor; the tests run the moment you do. Interview mode hides the example: solve it from memory, without the hint or the solution, and it counts as solved cold. Progress is saved in your browser, and in your account if you sign in.

More Select & Filter in SQL

All SQL exercises ยท Other languages and frameworks