I am using SQL Server 2010 with Visual Studio for my application. Now I have a table say "EmEmployeesand that have some 5000 records. This table has a column "Name" which is not a primary field. There is a possibility of more than one records having same name. Now I have to fetch all the records having duplicate names. What should be the efficient way to do this?
Please let me know.
to get the faster and possible correct help , always post table definition , sampled data plus expected output. see the link in my signature
-------Bhuvnesh----------I work only to learn Sql Server...though my company pays me for getting their stuff done;-)