查询去重无法去掉

[sinat_37552373]

查询的是一张动态表 ，获取发动态用户uid 如果有一样uid的就值获取最新的一条动态

SELECT t.tid,,t.uid
FROM uchome_square t
WHERE t.status = 1
ORDER BY sort desc,dateline desc
LIMIT 0,10

[sinat_37552373]

想实现一样的uid只保留一条记录 ，group by会把tid的顺序打乱

[青鬆下的坚躯]

想要这样的结果？

select *,max(tid) as tid from t2 group by uid

[青鬆下的坚躯]

引用 2 楼 青鬆下的坚躯 的回复:

想要这样的结果？

select *,max(tid) as tid from t2 group by uid

修正一下：

select max(tid) as tid, uid from t2 group by uid

[/quote]