Using mysql i need to retrieve which are inserted last in every category.

Posted by Fero on Stack Overflow See other posts from Stack Overflow or by Fero
Published on 2010-04-17T09:44:17Z Indexed on 2010/04/17 9:53 UTC
Read the original article Hit count: 201

Filed under:

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

© Stack Overflow or respective owner

Related posts about mysql-query