表名:TView_Inbox
id,uid,realname
5,162,张三
6,163,李四
7,162,张三
8,163,李四
9,164,王五
查出不重复单一记录
select * from TView_Inbox where id in (select MAX(id) from TView_Inbox group by uid)
结果
7,162,张三
8,163,李四
9,164,王五
表名:TView_Inbox
id,uid,realname
5,162,张三
6,163,李四
7,162,张三
8,163,李四
9,164,王五
查出不重复单一记录
select * from TView_Inbox where id in (select MAX(id) from TView_Inbox group by uid)
结果
7,162,张三
8,163,李四
9,164,王五