Wednesday, March 14, 2012

Find Duplicate Rows in SQL

Find how many repeated(duplicate) rows  in table
---------------------------------------------------------

select stdname,count(stdname) from tablename group by stdname having count(*) > 1
Posted by at

2 comments:

Subscribe to: Post Comments (Atom)