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 find the customer_id who placed orders for two days

1000972Apr 8 2013 — edited Apr 8 2013

Hi, I have a customers table like

ORDER_ID CUSTOMER_ID ORDER_DATE
__________________________________
1 | 100 |25-JAN-13
2 | 100 |25-JAN-13
3 | 100 |24-JAN-13
4 | 101 |23-JAN-13
5 | 101 |22-JAN-13
6 | 102 |21-JAN-13
7 | 102 |21-JAN-13

I would like to find the customer_ids who placed orders for two days

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2013

Added on Apr 8 2013

#pl-sql, #plsql, #sql

3 comments

170 views