Jump to content

Archived

This topic is now archived and is closed to further replies.

CptnChainsaw

SQL Query Problem ( How do I make this Query )

Recommended Posts

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 :)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.