![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
svsebad
这个作者很懒,什么都没留下…
展开
-
Oracle 查询并删除重复记录的SQL语句
查询并删除重复记录的SQL语句 查询及删除重复记录的SQL语句1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断select * from peoplewhere peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)2...原创 2009-01-03 21:36:21 · 73 阅读 · 0 评论 -
Oracle 两表连接的递归查询
Oracle 的递归查询: 1. 从上级递归查下级 select * from tbl_test start with id = ? connect by prior id = pid 2.从下级递归查上级select * from tbl_test start with id= ? connect by prior pid...原创 2009-02-12 21:51:50 · 1596 阅读 · 0 评论