dimanche 1 mars 2015

How to find most expensive items in sql with more than one most expensive item?

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