Posted by J.O. Aho on 12/16/06 21:09

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

[Back to original message]