比如有这样的数据 _____________________________________________________________________ ID USERID NAME TYPE _____________________________________________________________________ 0000001 00001 TOM 001 0000002 00001 TOM 002 0000003 00002 MIKE 001 0000004 00002 MIKE 002 0000005 00001 TOM 001 0000006 00003 NIKE 002 _____________________________________________________________________ 希望通过SQL查询出以下结果：(也就是通过ID，查询出每个USERID的最后一条数据)，请教各位，不胜感谢! _____________________________________________________________________ ID USERID NAME TYPE _____________________________________________________________________ 0000004 00002 MIKE 002 0000005 00001 TOM 001 0000006 00003 NIKE 002 _____________________________________________________________________ 心灵琴音界 灵透结界石

------
心灵琴音界
灵透结界石

Hi:    試試以下語法

SELECT  ID,
        USER_ID,
        NAME,
        TYPE
FROM    TABLE T1
WHERE   ID = (SELECT MAX(ID)
              FROM   TABLE T2
              WHERE  T1.USER_ID = T2.USER_ID)

-------------------------------- 小弟才疏學淺，若有謬誤請不吝指教 --------------------------------

------
Fishman

同樣用一個子查詢的方法, 給你參考看看: select * from table where id in (select max(id) from table group by userid) 發表人 - timhuang 於 2003/12/03 13:22:45