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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display zero value in blank fields of Cross Tab query 0
Can I save a sql statement generated by a search form? 1
Login Issues 0
Work Budget Salary vs Real Time Salary 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Creating a Chart on form from selected data in query. 0
Macro to select and delete levels of a document 2

Top