MySQL Qery for Displaying Latest Product's Received by Category

See more:

C#

Hi to all!

Can you help me about my problem in querying database records?

Here is the scenario..

I am developing an inventory system and it includes reports, views using datagrid. I have a product, product's category, receive and etc. I want to create a view of the latest received product by category, at least three of them. My problem is that I made a query for it and i use the LIMIT function of the mysql.

I need help in making database query which results to at least three latest products received by category. (Results must display at least three products each category).


Thank you ....