SQL Query Problem ( How do I make this Query )

[CptnChainsaw]

Anyone know how I can get the maximum ID for the first two records from a table where the categoryID = \"SomeValue\"?

 

In the example below if the categoryID = 5 then the maximum ID is 4 as I just want the first two records. How would I do this in SQL using MySQL?

 

 

//Example ( I just put the dots in to make it clearer )

 

ID....CategoryID.......Product_Name

3..............5.....................Fridge

4..............5....................Cooker

7..............5.............Microwave Oven

8..............5....................Freezer

9..............8.................DVD Player

10............8..................Computer

 

 

Cheers for any advice,

 

CptnChainsaw