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!

How to create SQL query based on 2 different IN clause

2632212Apr 15 2016 — edited Apr 15 2016

Hello All,

I am new to SQL and wondering how to create sql query based on following condition.

My requirement -

I have 4 country code ('PL' , 'SE', 'NO', 'DK') and I have 4 item numbers for only country code PL ('1234','2345','3121','6565') .

I have to select some values based on this 4 country code and also values should get selected for PL country code if that record contains above 4 item number. Item numbers must be check only for PL country code NOT for other country code. Except PL , data should be picked up just based on country code but for PL , data should be pick based on Country code is PL and if they contains above 4 item number only.

I hope I have clear my query as it is quite complex.

Could someone please help me on this as it is quite urgent?

Thanks,

Kushal Karia.

This post has been answered by Billy Verreynne on Apr 15 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 13 2016

Added on Apr 15 2016

#in, #pl-sql, #sql

12 comments

552 views