simple database query, I think!

[Oziam]

HI,

 

I have a table with over 100,000 rows, I want to query just one column and return the data

for each different result but only once. In other words, say I have a column named col1,

and it has approx 200 different entries in 100,000 rows, so some entries may have 100's of duplicates.

 

I want to return ONLY 1 instance of each unique entry, so I should get 200 unique results not 100,000 with

many duplicates. How to do this????

 

Thanks!

 

[Pikachu2000]

SELECT DISTINCT(`col1`) FROM `table`

[Oziam]

Yeah that worked great! Thanks!