SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Handling multiple conditions in single query

ZudarAug 31 2018 — edited Aug 31 2018

Hi,

I could really use some help figuring out the following..

I have a table, lets call it Table (simplified, but this is what my question comes down to):

Header_ID	Line_ID	Type_ID
201	0	8000001
201	0	8000012
201	1	5
202	0	8000037
202	0	8000009
202	0	8000003
202	1	4
203	0	8000056
203	0	8000012
203	0	8000013
203	0	8000019
203	0	8000008
203	1	2

I need to write a 'select' query based on this table that generates the following:

Header_ID	Type_ID	Type2_ID
201	8000001	5
201	8000012	5
202	8000037	4
202	8000009	4
202	8000003	4
203	8000056	2
203	8000012	2
203	8000013	2
203	8000019	2
203	8000008	2

Basically, for every unique Header_ID, I need to retrieve the Type_ID where Line_ID is 1 (Line_ID is always 0 or 1) and fill that in a new column Type2_ID, but without the lines where Line_ID is 1.

I'm quite lost at the moment and would appreciate some advice on this..

This post has been answered by Hans Steijntjes on Aug 31 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2018

Added on Aug 31 2018

#filter, #query, #select, #sql

8 comments

2,692 views