The best way to do the following?

  • Thread starter Thread starter dplove
  • Start date Start date
D

dplove

I have a table that has the following fields: System, Publisher, Package
name, version.

There is duplicate entries for "Package name" and "Version" (It can also be
a different version for the same package). What I would like to do is create
1 table or query that will list 1 entry of each Package name and each
version. What is the best way to do this?

Thanks
 
Use this query.

SELECT YourTable.Package, YourTable.Version
FROM YourTable
GROUP BY YourTable.Package, YourTable.Version;
 
Back
Top