-
Query Help - Merging two rows
Hi,
PFB the sample data.
CREATE TABLE "MY_TABLE"
("NBR" VARCHAR2(20 BYTE),
"MO_YR" NUMBER,
"EFF_DT" DATE
) ;
INSERT INTO MY_TABLE (NBR, MO_YR, EFF_DT) VALUES('101',201310,Sysdate-20);
INSERT INTO MY_TABLE (NBR, MO_YR, EFF_DT) VALUES('102',201310,Sysdate-15);
INSERT INTO MY_TABLE (NBR, MO_YR, EFF_DT) VALUES('103',201310,Sysdate-10);
INSERT INTO MY_TABLE (NBR, MO_YR, EFF_DT) VALUES('104',201310,Sysdate-5);
INSERT INTO MY_TABLE (NBR, MO_YR, EFF_DT) VALUES('105',201310,Sysdate);
COMMIT;
SELECT * FROM MY_TABLE;
Here, i need to get a dataset like this.
Prev. | Old | Eff DT
105 104 Sysdate
104 103 Sysdate-5
103 102 Sysdate-10
102 101 Sysdate-15
As you can see, i need to merge the two consecutive records in the above fashion. Thanks in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|