upon runing it , it returns a table that has multiple row duplicated. I need only one of each of the primary keys listed. The column ID is used as a primary key. then there are other columns that would contain the same info too.. What I need to do is only have one row of each of the primary key numbers? feild>>([5000Phantoms79w/VNos&othersFromAna].ID) In the primary key column "ID" The first column of the table each row might look like 1,1,1,1,1,4,5,6,7,7,7, and so on with multiple groups of repeated keys. How can I only have one of each of the primary key listed
So how do I add this this query to remove duplicate rows?
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: