|
|
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
Navigation:
[Reply to this message]
|