![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
malong~
这个作者很懒,什么都没留下…
展开
-
oracle查询某节点下的所有子节点
select cid,cname,cpid from yourtable connect by prior cid=cpid start with cid=1原创 2015-06-25 14:43:58 · 3880 阅读 · 0 评论 -
oracle分页查询语句
SELECT * FROM (SELECT A.*, ROWNUM numFROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM )WHEREnum>=1原创 2015-06-12 15:42:25 · 324 阅读 · 0 评论 -
查询重复数据的sql语句
select * from TableName where FieldName in(select FieldName from TabelName group by FieldName having(count(FieldName )>1)原创 2015-06-12 11:24:25 · 782 阅读 · 0 评论