hackiss
注册会员
UID 88887
精华
0
积分 67
帖子 54
金钱 67 喜悦币
威望 0
人脉 0
阅读权限 20
注册 2007-3-6
状态 离线
|
[推荐阅读] 北京-酷娃网诚聘英才！
感谢 Maxwin 出解法。
正解是
SELECT Uid, Score_id, Score
FROM
table as x
WHERE x.Score = (
SELECT MAX(Score)
FROM table as y
WHERE x.Uid=y.Uid
)
ORDER BY Uid;
如果需要列出MAX(Score)做个对照看看是不是要取得的行，
则：
SELECT Uid, Score_id, Score,MAX(Score)
FROM
table as x
WHERE x.Score = (
SELECT MAX(Score)
FROM table as y
WHERE x.Uid=y.Uid
)
GROUP By Uid
ORDER BY Uid;
此贴 封！！！
|
|
