How to query for unique values

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have a table with a field for Vendor. There are 60K line items in the
file. But only 30 vendors. So each vendor is repeated many times.

I want to build a query that will list each vendor only once. How would I do
that? Is there a built in function that I place in the criteria to only
return one value for each?

Dan
 
Dan said:
I have a table with a field for Vendor. There are 60K line items in the
file. But only 30 vendors. So each vendor is repeated many times.

I want to build a query that will list each vendor only once. How would I do
that? Is there a built in function that I place in the criteria to only
return one value for each?

Dan
Click to expand...

SELECT DISTINCT Vendor FROM Table;
 
Back
Top