Below is a list of the query that I am working on. There are part numbers that may be match to more than one module number. What I need is to show only the part numbers for the list. These part numbers I need a list of only one part number for each group.
PartNo------ Module------ Numbers
79000123-- ORTY123------- 1
I need a result that would look like
PartNo---------- Module------ Numbers
79000123---- QWST123-------2------ (it is just counting the pn column) 79000023-----RTY0023--------1
Could you give me a general statement that would just count the part numbers in the PartNo column and show the number of duplications, disregarding the Module numbers?
Software/Hardware used: MSXP, Windows 2000 Acess 2000
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: