Answer / saurabh dixit

DECLARE @people TABLE
(
name VARCHAR(32),
age INT
)
insert into @people
select Name,age From People group by Name,Age having COUNT(name)>1

delete People from People pe
join @people p on pe.name=p.name and pe.age=p.age

Answer / prakash patel

delete from tbl_test where ID in
(select ID from tbl_test group by ID having count(ID) > 1)

Answer / vaishali

set rowcount 1
delete from stud
where (select count(*) from stud a where stud.roll_no =
a.roll_no) > 1
while @@rowcount<>0
delete from stud
where (select count(*) from stud a where stud.roll_no =
a.roll_no) > 1
set rowcount 0

Answer / shashank shrivastava

Table-admin
------------------
adminID adminName
1 admin
2 tester
3 admin

SQL:
---------------
DELETE admin.* FROM admin,
(SELECT count(adminName) as c, MAX(adminID) as m from
admin GROUP BY adminName HAVING c>1) as new_admin
WHERE admin.adminID=new_admin.m

Answer / senthilsjc

This query delete duplicate records(but not delete both
duplicate)
set rowcount 1
delete yourtable
from yourtable a
where (select count(*) from yourtable b where b.name=a.name
and b.age=a.age)>1
while @@rowcount >0
delete yourtable
from yourtable a
where(select count(*) from yourtable b b.name=a.name and
b.age=a.age)>1
set rowcount 0

Answer / subrata paul

Delete TOP(1)from example where[ID]=1

Answer / ashish kumar

select * from dbo.duplicatetest
set rowCount 1
delete from dbo.duplicatetest where iD=1;
set rowCount 0

Answer / rajkamal

delete form emp
where (select distinct(ename)from emp)

Answer / vinod singh kushwah

Delete From Tablename where(ID Not in (Select max(ID) from
Tablename Group by name))

Tablename :Friend

ID Name Age city
101 vinod 22 Gwalior
102 Pritesh 23 Gwalior
102 Pritesh 23 Gwalior
103 Arvind 24 Gwalior


Here Id-102 is repeated so friend if u want to delete this
duplicate raw Try Above code in Sql-sever

Answer / anuj

You have Two option You can use keyword Distinct or Group By Both will help you to delete dublicate records

How do I view a procedure in sql server?

1 Answers  

what is sql injection in sql server?

2 Answers   TATA,

Explain different types of collation sensitivity?

1 Answers  

What is advantage data architect?

1 Answers  

What is the difference between for trigger and after trigger?

1 Answers  

Explain cross join or cartesian product in sql?

1 Answers  

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

What are the different Topologies in which Replication can be configured?

1 Answers  

internal language used in sql server 2000?

2 Answers  

Which sql server table is used to hold the stored procedure script?

1 Answers  

what are batch in sql server?

2 Answers   Satyam,

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,