cross apply

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

满足了