find duplicate field values in database using SQL

select empid,count(*) from emp
group by empid
having count(*)>1

this can help you to find dup values on specified field (in this example,
empid ) .