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

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

how many type of indexing in database?

0 Answers   IBM,

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

create index a on employee(dno) In this,which index was created?

2 Answers  

What are exact numeric data types in ms sql server?

0 Answers  

What is difference between inner join and full join?

0 Answers  

How to get the definition of a stored procedure back?

0 Answers  

How do you fine the performance tunning?

2 Answers   Accenture,

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  

What is an execution plan? When would you use it?

0 Answers