CptnChainsaw Posted June 28, 2003 Share Posted June 28, 2003 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.