sql 取代游标的写法示例

内容摘要

Update Tb_Garden1 G Set Steward = (
Select Id From Zyq.Tb_User U Where Replace(U.Name, '区') = G.Name And Rownum =1)
where exists (select 1 from zyq.tb_user u

文章正文

Update Tb_Garden1 G Set Steward = (
Select Id From Zyq.Tb_User U Where Replace(U.Name, '区') = G.Name And Rownum =1)
where exists (select 1 from zyq.tb_user u where Replace(U.Name, '区') = G.Name And rownum = 1)

代码注释

上一篇 CSS的相邻兄弟选择器用法简单讲解下一篇 CSS实现的中英文双语菜单效果代码

作者：喵哥笔记

学的不仅是技术，更是梦想！