Deviopath › PostgreSQL

Three Most Expensive

Easy · Sorting

LIMIT n keeps only the first n rows of the result. It goes after ORDER BY. If prices tie, you need a second sort column so the result is always the same.

Return the name and price of the 3 most expensive products, sorted by price from highest to lowest, then by name A to Z.

Next: Page Two of the Catalog