表money
TID | Money | UID |
1 | 22 | 1 |
2 | 32 | 2 |
3 | 12 | 1 |
4 | 32 | 2 |
5 | 34 | 1 |
select * from money a join (select max(TID) from money group by UID order by UID desc limit 12) b on a.TID=b.TID
表money
TID | Money | UID |
1 | 22 | 1 |
2 | 32 | 2 |
3 | 12 | 1 |
4 | 32 | 2 |
5 | 34 | 1 |
select * from money a join (select max(TID) from money group by UID order by UID desc limit 12) b on a.TID=b.TID