PL/SQL Finding Duplicate Values in a Table

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

Comments

Popular posts from this blog

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Solution for "Can not obtain Oracle client information from registry"