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)