Cita:
Iniciado por Libras 
si puedes hacer algo asi
select * from tabla group by id having count(id)=1
select * from(
select row_number() over (partition by id order by id) as rn, * from tabla
) as t1 where rn=1
saludos!
Ufff......grande Maestro.....gracias.....justo lo que necesitaba.