InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 23:23:13 GMT20http://www.sqlservercentral.com/Forums/Topic1410438-1292-1.aspxselect <field list req'd>from <your table>where <field with dupes> in (select <field with dupes> from <your table> group by <field with dupes>having count(*) > 1)Wed, 23 Jan 2013 04:12:47 GMTlestatf4http://www.sqlservercentral.com/Forums/Topic1410438-1292-1.aspxYes, or use GROUP BY and HAVING. Sounds suspiciously like an interview or homework question to me.JohnWed, 23 Jan 2013 03:59:40 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic1410438-1292-1.aspx[code="sql"]select name from (select name, row_number() over ( partition by name order by name ) rnkfrom EmEmployeesand) t where t.rnk > 1 [/code]Wed, 23 Jan 2013 03:49:11 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1410438-1292-1.aspx[quote][b]girish.nehte-1109699 (1/23/2013)[/b][hr]Hi,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.Regards,Girish[/quote] to get the faster and possible correct help , always post table definition , sampled data plus expected output. see the link in my signatureWed, 23 Jan 2013 03:46:09 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1410438-1292-1.aspxHi,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.Regards,GirishWed, 23 Jan 2013 03:21:46 GMTgirish.nehte-1109699