Select min(ID) as ID, value from myTable group by Value
>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