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