finding duplicate names in a column

[aniltc]

hi


I have 2 field in my table as

id and name


id Name

1 asd
2 asd
3 asd
4 acv
5 USD
6 USD
7 acx
8 zxc
9 xcv
10 ZXb

I want to find out the duplicates names and their id and how many times a particular name duplicates ?

is it possible? please help me

Thanks

[r937]

select t.id
     , t.Name
     , d.dupes
  from daTable as t
inner
  join (
       select Name
            , count(*) as dupes
         from daTable
       group
           by Name
       having count(*) > 1
       ) as d
    on d.Name = t.Name

[aniltc]

Thanks
you have used both join and subquery here ?

[r937]

yes i have