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

What is the Control Flow in SSIS

0 Answers   HCL,

Can we install sql server 2016 on windows 7?

0 Answers  

How to get the number of affected rows?

0 Answers  

How to create a view on an existing table in ms sql server?

0 Answers  

How do you rebuild an identity column?

0 Answers  

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

How to find the source of a table in sql server?

0 Answers  

Is it safe to delete log files?

0 Answers  

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

What do you need to connect php to sql server?

0 Answers