|
Re: Sql - I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.
Quote:
Originally Posted by radhika_btech
Sql - I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.
|
select name, count(name)
from table_name
group by name
having count(name) > 1
Last edited by ketan_kashyap@yahoo.co.in; 10-03-08 at 02:24 PM.
Reason: mistake
|