SELECT * FROM mytable mt1 WHERE NOT EXISTS ( SELECT 1 FROM mytable WHERE value = mt1.value AND id < mt1.id ) - or SELECT * FROM mytable mt1 WHERE id = ( SELECT MIN(id) FROM mytable WHERE value = mt1.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