Coding task · SQL and MySQL course · Module 11: Capstone project

Most expensive books - LIMIT

Limit the number of results to show only the top of the shelf.

Task

Write a query that retrieves tytul and cena from the ksiazki table, sorts the results descending by price and shows only the first 3 rows. Use ORDER BY ... DESC and LIMIT.