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.