troubleshooting Question

How to only return duplicates n this SQL query

Avatar of Butler Bros
Butler BrosFlag for United States of America asked on
4 Comments1 Solution14 ViewsLast Modified:
I wish to return only those rows in which the 'counts' is > 1

  SELECT  alternate_code.alternate_code ,         
 inv_mast.item_id ,        
 alternate_code.alternate_code_uid ,
COUNT(*) OVER (PARTITION BY  alternate_code.alternate_code ) counts 
 FROM alternate_code
    INNER JOIN inv_mast ON inv_mast.inv_mast_uid = alternate_code.inv_mast_uid
	Group by alternate_code.alternate_code, inv_mast.item_id,alternate_code.inv_mast_uid, alternate_code.alternate_code_uid 

Open in new window

Join our community to see this answer!
Unlock 1 Answer and 4 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 4 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