sqlserver中,用于一对多连接
inner join必须有on,写上关联条件
cross apply不需要on
要求:查询每个学生最近两次的考试成绩
SELECT a.id, a.name, b.score
from TempStudent a
inner join TempScore b on b.TempStudentId = a.id
满足不了
SELECT a.id, a.name, b.score
from TempStudent a
cross apply (SELECT top 2 * from TempScore where TempStudentId = a.Id ORDER BY score desc) b
满足了