duplicate rows?

hi all..
how will i fetch duplicate rows in a table i want the count also
eg in my table if the same company name exist morethan once i want to fetch it
thnks in advance
Jagduplicate rows is not the same thing as multiple rows with the same value in a particular column

presumably if your table has a primary key, you will never have a duplicate row

for your question about company names, try this --select companyname
, count(*) as rows
from daTable
group by companyname
having count(*) > 1|||u r right
its not duplicate its multiple nd thnks for ur querysql