SELECT A.* FROM @t AS A INNER JOIN (SELECT ID,MAX(SL)AS SL FROM @t GROUP BY ID) AS B ON A.ID=B.ID AND A.SL=B.SL ORDER BY ID求采纳
