If you want to select more fields than you showed here, then you can use derived tables, e.g.
select myTable.* from myTable inner join
(select min(ID) as MinID, value from myTable group by value) MinSQL
on MyTable.ID = MinSQL.MinID
>To all sql guru's pls. help on this query. I'd like to eliminate those duplicate values. I want to remain only those 1st occurences.
>
>ID Value
>
>1 001
>2 001
>3 001
>4 002
>5 002
>6 003
>7 004
>8 004
>9 004
>10 004
>
>The result would be like this
>
>ID Value
>
>1 001
>4 002
>6 003
>7 004
>
>
>Appreciate your help.
>
>Tnx in advance.
If it's not broken, fix it until it is.
My Blog