I'd like to write a simple select query. In a particular 1000-row db I
have one column (field) where many of the rows (records) have the same
entry. I'd like to write a query that returns all the different entries
in that column, but each one only once.

grant wrote:
> I'd like to write a simple select query. In a particular 1000-row db I
> have one column (field) where many of the rows (records) have the same
> entry. I'd like to write a query that returns all the different entries
> in that column, but each one only once.

Use DISTINCT

example: SELECT DISTINCT field FROM mytable


--

//Aho

Post removed (X-No-Archive: yes)