很...的问题!!!

[zdy]

怎么样把一个表中的记录提出来,如果是属于一个用户号的我需要
把ttid(一个数值字段)字段值最大的提取出来!!!!!!!
userid ttid yy
1 777 32
2 777 23
3 22 32
4 333 33
1 888 90
---------------------------
提取的结果应该是:
userid ttid yy
2 777 23
3 22 32
4 333 33
1 888 90
--------------------------
注意我想用sql写!!!!!!!!
希望各位关注!!!!
谢谢各位了!!!!!!!!!

[kkk321]

Wingsun的方法是对的!

[LaoZheng]

select DISTINCT(userid),ttid,yy from test order by ttid

[Wingsun]

SQL Server:
SELECT userid, MAX(DISTINCT ttid) as ttid FROM Table GROUP BY userid

[Wingsun]

SELECT userid, MAX(DISTINCT ttid) as ttid FROM Table GROUP BY userid

[kkk321]

1.用游标
2.用本表关联

[7030]

select * from Table group by ttid,yy,userid
group by 后ttid一定要放在第一位!!
如果表还有其它字段，group by 后面一定要加上。

[halfdream]

select userid ,max(ttid),yy from t4
group by userid
应该就行了吧。

[kxy]

select userid,ttid=max(ttid),yy=max(yy) from table group by userid

[ymxxm]

select max(ttid),max(yy) from table where userid=:userid