sql doubts

• asranantha

  SSCarpal Tunnel

  Points: 4246

  More actions

  November 14, 2011 at 10:34 pm

  #246064

  Hello friends,

  I have a one problem, i have a table in that some reocrds are duplicate.i want to find which records are duplicate.

  for exp. my table is as follows

  emp_id emp_name

  1 aa

  2 bb

  3 cc

  1 aa

  3 cc

  3 cc

  and i want the result is like

  emp_id emp_name

  1 aa

  1 aa

  3 cc

  3 cc

  3 cc

• ColdCoffee

  SSC-Dedicated

  Points: 39972

  More actions

  November 14, 2011 at 11:03 pm

  #1407621

  A GROUP BY and HAVING COUNT(*) > 1 will give you what you want.

  And this is a cross post: Please redirect ur replies to : http://www.sqlservercentral.com/Forums/Topic1205657-392-1.aspx