自连接

sql语句:SELECT * FROM dbo.tbstudent AS a INNER join (SELECT studentid , MAX(classid) AS classid FROM tbstudent  GROUP BY studentID) AS b  ON a.studentID = b.studentid AND a.classID = b.classID