本文介绍如何在Oracle数据库中对多行数据进行合并，并去除重复记录的查询方法，分享来自ITPUB博客的实用技巧。
创建测试表，并插入测试数据
SQL> create table t5(deptno int,name varchar2(20),say number);
Table created.
SQL> insert into t5 values(30,'jason',5000);
1 row created.
SQL> insert into t5 values(30,'susie',8000);
1 row created.
SQL> insert into t5 values(40,'jack',3000);
1 row created.
SQL> insert into t5 values(50,'smith',4000);
1 row created.
SQL> insert into t5 values(50,'july',6000);
1 row created.
SQL> commit;
Commit complete.
SQL> create table t5(deptno int,name varchar2(20),say number);
Table created.
SQL> insert into t5 values(30,'jason',5000);
1 row created.
SQL> insert into t5 values(30,'susie',8000);
1 row created.
SQL> insert into t5 values(40,'jack',3000);
1 row created.
SQL> insert into t5 values(50,'smith',4000);
1 row created.
SQL> insert into t5 values(50,'july',6000);
1 row created.
SQL> commit;
Commit complete.
最低0.47元/天 解锁文章
扫一扫
1426
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
