![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
corey_qz
这个作者很懒,什么都没留下…
展开
-
oracle去重重复行
select sum(count(1))-count(1) from table group by id having count(1)>1 --查询重复行数 select count(1) from table where _id in (select _id from table group by _i...原创 2019-12-25 15:25:58 · 386 阅读 · 0 评论 -
oracle 列转行,行转列
复制表结构和数据 CREATE TABLE table_name AS SELECT * FROM old_table_name; 只复制表结构 CREATE TABLE table_name AS SELECT * FROM old_table_name WHERE 1=2 With as 临时表 With t as (select 1 id,2 pid from dua...原创 2018-12-25 11:09:34 · 4306 阅读 · 0 评论