Sql Query

V

vasuki

Can You please help me in Designing a query which
select the Duplicate values which is Phone number or Name or Address
 
M

Michael Bednarek

Can You please help me in Designing a query which
select the Duplicate values which is Phone number or Name or Address
Click to expand...

Searching Google for "sql select duplicate records" throws up many
links. One of the first is
<http://www.sqlteam.com/item.asp?ItemID=3331>. It suggests a method
along the following lines:

select phone_number, name, address, count(*)
from your_table
group by phone_number, name, address
having count(*) > 1
 
Top