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
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