Skip to Main Content

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 return records questions

KRelayJun 17 2014 — edited Jun 18 2014

say I have 5 rows of data:

Date    Activity

1/21     1

1/28     1

2/5      1

1/21     2

2/5      2

How do I write a query so that it returns activity only when it has 1/21 and 2/5 populated but not 1/28?  Basically I need something that will return activity 2 back. 

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2014
Added on Jun 17 2014
12 comments
136 views