Posted by Tom on 12/19/06 19:34

On Sat, 16 Dec 2006 21:04:17 GMT, 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.


Maybe this, which also provides a count for each unique entry...

SELECT count(field), field FROM table GROUP BY field;

Tom
--
Newsguy.com - Express Accounts - 30 GB $9.95 / month

[Back to original message]