I need to "List all details of the 5 highest prize money, descending order by money." I ran this query first:

select * from prize
order by money desc;

Then, seeing the 5th highest figure was >60, I ran this query:

select * from prize
where money > 60.00
order by money desc;

How can I combine these two into one statement?

MySQL includes a nice feature called LIMIT which can be included in your SQL statement. This effectively limits the number of rows returned:

Thanks for this, Ronan.

However, returning 5 rows isn't the correct answer because there are two records which have the same prize amount. The answer should display 6 rows, and I know LIMIT 6 would do that, but is there a statement that will return the 5 highest prizes without knowing how many records this covers? Eg, what if there were 25 records which all fall into the top 5 prize amounts?
In other words, do I need to look at the data to work out how many records should be returned in my query before being able to create this query, or can I create a query which will do it all for me?

Thank you.
Unfortunately this returns four rows.

yeah, you're right, i didn't have enough information

could you please help me out and do a SHOW CREATE TABLE

i will fix the query accordingly

It is possible to include a LIMIT into a SELECT statement so long as it is not a subquery. So you could do this:

Many thanks, Rudi and Rowan.
Rowan's query works.

Actually it is Ronan but never mind glad the query works.