Sql Server cross apply和outer apply

最新推荐文章于 2024-06-17 15:38:21 发布

ラピスラズリ(Dawn)

最新推荐文章于 2024-06-17 15:38:21 发布

阅读量118

点赞数

分类专栏： sql server数据库

本文链接：https://blog.csdn.net/tm772665493/article/details/99911102

版权

sql server数据库专栏收录该内容

14 篇文章 0 订阅

订阅专栏

with result as(
select t.str from(
select '1' str
union all
select '2' str
union all
select '3' str
union all
select '4' str
union all
select '5' str
union all
select '6' str
union all
select '7' str
) t
cross apply
(select t2.str from(
select '1' str
union all
select '2' str
union all
select '3' str
union all
select '4' str
) t2
where t.str = t2.str) t3)
select * from result;
go

with result as(
select t.str from(
select '1' str
union all
select '2' str
union all
select '3' str
union all
select '4' str
union all
select '5' str
union all
select '6' str
union all
select '7' str
) t
outer apply
(select t2.str from(
select '1' str
union all
select '2' str
union all
select '3' str
union all
select '4' str
) t2
where t.str = t2.str) t3)
select * from result;
go

select t.str from(
select '1' str
union all
select '2' str
union all
select '3' str
union all
select '4' str
union all
select '5' str
union all
select '6' str
union all
select '7' str
) t
cross apply
(select t2.str from(
select '1' str
union all
select '2' str
union all
select '3' str
union all
select '4' str
) t2
where t.str = t2.str) t3;
go