![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
常用SQL笔记
小昌呀
金蝶开发实施,解决各种疑难杂症!
展开
-
SQL查询所有上级/查询所有下级
--Oracle--取所有的上级代码select a.fnumber,a.fid,a.fParentID,level from T_ORG_Admin a start with a.fnumber = 'ZHPH' connect by prior a.FParentID = a.FIDorder by level desc--取所有的下级代码select a.fnumber,a.fi...原创 2019-10-03 21:57:11 · 1304 阅读 · 0 评论 -
SQL删除重复数据/保留一条重复数据
delete from CT_FIN_ExpenseTypeConfEntry where cfexpensetypeid in --找出重复数据( select etce.cfexpensetypeid from CT_FIN_ExpenseTypeConfEntry etce left join CT_FIN_ExpenseTypeConf etc on etce.fpare...原创 2019-10-03 21:58:08 · 169 阅读 · 0 评论