Hello,
My row_over partition is giving me trouble to get all the records as single row based on the primary key. something not working quite right. Can someone please suggest me a solution please?
create table test (empno number, salary number, dept_1 number, dept_2 number, dept_3 number, dept_4 number, join_date date);
insert into test values (1, 10000, '100', null, null, null, '01-jan-1999');
insert into test values (1, 10000, null, 200, null, null, '01-jan-1999');
insert into test values (1, 10000, null, null, 300, null, '01-jan-1999');
insert into test values (1, 10000, null, null, null, 400, '01-jan-1999');
insert into test values (2, 20000, '100', null, null, null, '01-jan-1999');
insert into test values (2, 20000, null, 200, null, null, '01-jan-1999');
insert into test values (2, 20000, null, null, 300, null, '01-jan-1999');
insert into test values (2, 20000, null, null, null, 400, '01-jan-1999');
commit;
select * from test;
Expected output.
empno salary dept_1 dept_2 dept_3 dept_4 join_date
1 10000 100 200 300 400 01-JAN-99
2 20000 100 200 300 400 01-JAN-99