Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding Duplicate Records

Status
Not open for further replies.
Kgcounts

Kgcounts

Programmer
Aug 2, 2001
1
US
I have a table that an ASP program entered in duplicate records. I am wanting to identify all of the duplicate records in the table based on values from two columns. I have not been able to get a select statment to work. Does anyone know the proper syntax?
 
Sort by date Sort by votes

Select col1, col2, count(*) As RecCnt
From tbl
Group by col1, col2
having count(*)>1 Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Adding field duplicates records
Replies
16
Views
796
Chris Miller
Chris Miller
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
750
Chris Miller
Chris Miller
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
980
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Duplicate Rows 1
Replies
4
Views
349
Cpreston
Cpreston
bmacbmac
  • Locked
  • Question
SQL 'For json' query for over 100,000 records - truncating results
Replies
2
Views
936
bmacbmac
bmacbmac

Part and Inventory Search

Sponsor

Back
Top