https://docs.microsoft.com/zh-cn/sql/relational-databases/performance/subqueries?view=sql-server-ver15
sqlserver 官方文档
原文:https://www.cnblogs.com/hao-1234-1234/p/12327284.html