Tuesday, March 2, 2010

Getting Duplicate Records in a table

Declare @temp table(id int,name varchar(30),age int)INSERT INTO @temp values(1,'faheem',12)INSERT INTO @temp values(2,'ahmad',12)INSERT INTO @temp values(1,'faheem',12)INSERT INTO @temp values(3,'faheem',14)
select id,name,age,count(*) from @tempgroup by id,name,agehaving count(*)>1

No comments:

Post a Comment