SQL Developer

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!

I need help on This SQL problem ASAP :)

807700Oct 24 2010 — edited Oct 24 2010

Hi All,

I need help on this....

I have a table...

Say table name: one

with these values

premnum status
1234 C
1234 F
1234 P
1234 F
5678 C
5678 F
5678 P
9112 C
9112 F
9112 P
9112 F
3456 C
3456 F
3456 P
7890 C
7890 P
7890 F

Now, I want to output only those premnum with status = 'C' and those premnum with Status 'F' having a count > 1 (with two status = 'F')
So the output would be something like this
premnum status
1234 C
1234 F
1234 F
5678 C
9112 C
9112 F
9112 F
3456 C
7890 C

I really need help on this asap...
I need the SQL statement on this....

Thank you in advance. :)

Edited by: 804697 on Oct 23, 2010 9:45 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 21 2010

Added on Oct 24 2010

#help, #sql-developer, #sqldeveloper

2 comments

128 views