Interview question

This question is step 5 of the course “Your first database”

LIMIT without ORDER BY

easy~4 min

A colleague wants to show the three newest products on the home page and writes SELECT title FROM goods LIMIT 3. On the test database everything looked right. What's wrong with this query, and how do you fix it if the date a product was added is in the added_at column?

Just like in an interview: answer in your own words, and the AI will mark which key points you covered. To pass, cover more than half of them.

Loading…