troubleshooting Question

Pl SQL Oracle

Avatar of Jamil Muammar
Jamil Muammar asked on
Oracle DatabaseSQL
5 Comments1 Solution123 ViewsLast Modified:
Dear Experts,
 I have tables contain 3 columns as a key, cannot have 2 rows with the same keys value.
The coulm are: YEAR_MONTH, Customer, product.

How do I by creating a view display all the rows that having more than row in the same keys

For Example, for the following table
YEAR_MONTH    -    Customer     - Product
201803                  cust1                  prod1
201911                  cust2                  prod2
201803                 Cust1                   Prod1

the out view will be
201803   Cust1   Prod1 2(times)

Russ SuterSenior Software Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros