i have an invoice file that has the same vendor number multiple times.  how do I create a result set with just the distinct/unique values of the vendor #?

What about:

Select Distinct Col1, Col2, ... ColN
   from yourTable;

i have an invoice file that has the same vendor number multiple times.  how do I create a result set with just the distinct/unique values of the vendor #?

I used distinct, but the vendors were still there more than once...

What about:

Select Distinct Col1, Col2, ... ColN
   from yourTable;

i have an invoice file that has the same vendor number multiple times.  how do I create a result set with just the distinct/unique values of the vendor #?

just realized i had another column in the select statement, so the distinct was returning multiple occurs...  Will distinct list unique occurrences for vendor # for each different column in the select (that might be useful)? 

I used distinct, but the vendors were still there more than once...

What about:

Select Distinct Col1, Col2, ... ColN
   from yourTable;

i have an invoice file that has the same vendor number multiple times.  how do I create a result set with just the distinct/unique values of the vendor #?