Using mysql i need to retrieve which are inserted last in every category.
- by Fero
Hi,
My prob in brief:
I have two tables namely category and product.
table: category
id category
1 cat1
2 cat2
3 cat3
4 cat4
table: product
id productName category
1 test1 1
2 test2 2
3 test3 3
4 test4 4
5 test5 2
6 test6 2
My prob is:
I need products which are inserted last in every category.
How to solve this.
thanks in advance