sql语句中实现循环匹配

最新推荐文章于 2025-01-05 10:18:00 发布

iteye_194

最新推荐文章于 2025-01-05 10:18:00 发布

阅读量792

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL 文章标签： SQL C C++ C#

本文链接：https://blog.youkuaiyun.com/iteye_194/article/details/81639867

SQL 专栏收录该内容

11 篇文章

订阅专栏


select A.*,
(select top 1 
B.b
from
(
select 
'a' as a ,'1' as b
union
select 
'b' as a ,'2' as b
union
select
'd' as a ,'3' as b
union
select
'a' as a ,'4' as b
)B where A.a = B.a) as changA

from

(
select 
'a' as a ,'1' as b
union
select 
'b' as a ,'2' as b
union
select
'c' as a ,'3' as b
)A ;