We have to use the group by with having command to get the duplicate values. this query shall show the result of only the users have duplicate values in the employee table.
SELECT columnName FROM TableName
Group By columnName
Having Count(*)>1
How to get duplicate records from the Database
,
Labels:
asp.net developer,
database,
duplicate records,
multiple records,
Sql Server
Wednesday, April 14, 2010
Subscribe to:
Post Comments (Atom)
Posts
0 comments:
Post a Comment