21,882
社区成员
发帖
与我相关
我的任务
分享
create table lk7(
tid int,
uid int);
insert into lk7 values
(1,3),
(2,5),
(3,3),
(4,3),
(5,6),
(6,7),
(7,5),
(8,7),
(9,6);
select * from (select * from lk7 order by tid desc) T group by uid order by tid desc;
query result(4 records)
tid uid
9 6
8 7
7 5
4 3