select lastest 2 element group by a topic_id

Posted by Luca Romagnoli on Stack Overflow See other posts from Stack Overflow or by Luca Romagnoli
Published on 2010-04-07T23:01:59Z Indexed on 2010/04/07 23:13 UTC
Read the original article Hit count: 183

Filed under:
|
|

Hi i have to select the 2 lastest element for every topic

ex: table: msg

id  |   topic_id
-----------
1  |  1
2  |  1
3  |  1
4  |  1
5  |  2
6  |  2
7  |  2
8  |  3

i want obtain these rows:

3 1
4 1
6 2
7 2
8 3

How can i do?

thanks

© Stack Overflow or respective owner

Related posts about mysql

Related posts about select