Answer / karna

delete from emp where empid not in(select max(empid) from
emp group by empname having count(*)>=1)

Answer / jiri

WITH DUPLICATE(EmpName, RowNumber)
AS
(SELECT EmpName,ROW_NUMBER() OVER (PARTITION BY EmpName
order by EmpName) AS RowNumber
FROM Employee)

DELETE FROM DUPLICATE WHERE RowNumber > 1

------------------------------------------------------------
Using CTE (Common Table Expressions) and ROW_NUMBER as
ranking fucntion


Jiri JANECEK
MSE, MBA, MCSD.NET

Answer / ambarish

we can use cursor.

Answer / venkat

Hope this methodology would help you better

1.Create a temp table
2.Select duplicated row's empid,empname into the temp table.
3.Create a cursor by selecting values from temp table.
4.Keep either min or max(empid) from original table and
delete the rest of the duplicated rows.

Answer / kumar

Table structure :-

empid empname
1 bala
2 bala
3 bala
4 bala
5 arun
6 arun
7 arun
8 ram
9 ram

Delete from employee where empid
not in (Select min(empid) from employee group by emp
having count(empid)>1)

By
Kumar

Answer / dinesh gupta

Kumar your query do not solve the purpose accurately.

It should be as

Delete from employee where empid
not in (Select min(empid) from employee group by empname
having count(empname)>=1)

Answer / dinesh gupta

use distinct commond

distinct(ename) from table name

How to create a ddl trigger using "create trigger" statements?

0 Answers  

What is the standby server?

0 Answers  

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

How do I view views in sql server?

0 Answers  

user defined datatypes

1 Answers   Wipro,

Name three version of sql server 2000 and also their differences?

1 Answers  

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

HOW TO RENAME A COLUMN NAME

3 Answers  

what is unique and xaml nonclustered index

0 Answers  

What is the difference between push and pull subscription? : sql server replication

0 Answers  

Is trigger fired implicitely?

2 Answers  

Explain the dirty pages?

0 Answers