SQLserver With As 用法

地址：https://blog.csdn.net/u012571917/article/details/79816988

select * from person.StateProvince where CountryRegionCode in
(select CountryRegionCode from person.CountryRegion where Name like ‘C%’)

=================相当于
with
cr as
(
select CountryRegionCode from person.CountryRegion where Name like ‘C%’
)

select * from person.StateProvince where CountryRegionCode in (select * from cr)