duplicate rows??

jagans · #1 (**permalink**) 02-20-06, 05:29

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
Jag

r937 · #2 (**permalink**) 02-20-06, 08:22

duplicate 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 --

Code:

select companyname
     , count(*) as rows
  from daTable
group by companyname
having count(*) > 1

jagans · #3 (**permalink**) 02-21-06, 00:37

u r right
its not duplicate its multiple nd thnks for ur query

Internet Services

Web Development

Digital Marketing

Consumer Tech