How to select the five greatest number mysql

Question

Hi, How to select the first five high number from my table for example: bid_table > 10 customers enter bid, and the query need to give only the five high bid from this 10 customers

thanks Yaniv

Answer 1

SELECT bid FROM bid_table
ORDER BY bid DESC
LIMIT 5;

The limit clause gives you just five results. The order by and desc parts give the results from highest to lowest.

Answer 2

SELECT * FROM bid_table ORDER BY bid DESC LIMIT 5;