Re: find duplicates

you could count the number of instances of each value and only return those with more than 1 occurence:

select ks,count(*)
from my_tab
group by ks
having count(*)> 1
/

Mark Stratford Received on Tue Jan 14 2003 - 09:56:16 CST