Saturday, 26 July 2014

select duplicate records in oracle

select column_name, count(column_name)
from table
group by column_name
having count (column_name) > 1;

No comments:

Post a Comment