摘要:
谓词ANY和ALL,我从不需要使用1. ANY以下两个query会返回相同的结果和执行计划?12345678910111213select*fromSales.SalesPersonwhereTerritoryID = ANY(selectTerritoryID fromSales.SalesTerritory whereCountryRegionCode = 'US')select*fromSales.SalesPersonwhereTerritoryID in(selectTerritoryID fromSales.SalesTerritory whereCountryRe 阅读全文