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
自连接
最新推荐文章于 2024-09-14 19:55:29 发布
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