I have more than one items with the highest price on my database and I would like to know how to return the most expensive items with the highest price on my database, without using LIMIT. I have tried using
SELECT MAX(price) from items
but it only returns one item with the highest price (I have two items with the highest price).
The schema of my database is
items (itemID: integer, description: string, price: integer)
Aucun commentaire:
Enregistrer un commentaire