Navigation

4Guys
ASP.NET
Home
dasBlog

Search

Categories

 
 
 
 
 
 
 
 
 
 
 
 
 
 

On this page

A SQL Query to Find Duplicate Values

Archive

November, 2008 (4)
October, 2008 (1)
September, 2008 (8)
July, 2008 (4)
June, 2008 (3)
May, 2008 (8)
April, 2008 (21)
March, 2008 (4)
February, 2008 (2)
January, 2008 (8)
December, 2007 (8)
November, 2007 (11)
October, 2007 (5)
September, 2007 (1)
August, 2007 (1)
July, 2007 (11)
June, 2007 (24)

Blogroll

 Tim Mackey

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

RSS 2.0 | Atom 1.0 | CDF

Send mail to the author(s) E-mail

Total Posts: 125
This Year: 63
This Month: 4
This Week: 1
Comments: 0

Sign In

 Thursday, June 07, 2007
A SQL Query to Find Duplicate Values
Thursday, June 07, 2007 10:11:39 AM (Eastern Standard Time, UTC-05:00) ( )

SELECT <KEY_COLUMN>, COUNT(*)
FROM <TABLE>
GROUP BY <KEY_COLUMN>
HAVING COUNT(*) > 1

Comments [0] | Trackback | # 
Related posts:
Using Multiple Active Result Sets (MARS) to Execute Multiple Commands on a Connection
SQL Server Information_Schema
SQL Collation Conflict
REPLACE Function for a SQL Server Text Field
Getting the ID value of the most recently added record
Common Solutions for T-SQL Problems