SQL query to return all rows that contain duplicate data from one field

Question

I have a table with card numbers and names. Some of those names are the same, meaning they have multiple cards. How can I select all the rows where the name occurs more than once?

Answer 1

select count(*) as n, [name]
from table1
group by [name]
having n > 1

Answer 2

The following should work:

SELECT        * 
FROM cards    c1 
INNER JOIN    cards c2 on c1.name = c2.name 
WHERE         c2.id <> c1.id

Answer 3

Following may be the solution you are looking for

Select * from CardTable where cardid in ( select cardid from CardTable group by cardid having count(cardid) > 1)

Answer 4

Use:

  SELECT t.name
    FROM TABLE t
GROUP BY t.name
  HAVING COUNT(*) > 1

Answer 5

if you need the whole rows, here is a solution that will work on sql 7 and up

SELECT t1.* FROM(
 SELECT t.name
    FROM YourTable t
GROUP BY t.name
  HAVING COUNT(*) > 1) t2
  JOIN YourTable t1 on t2.name = t1.name