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

Different types of keys in SQL?

0 Answers   Infosys,

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

What do you need to connect php to sql server?

0 Answers  

What is the language structure to add a record to a table?

0 Answers  

What is difference between standardization and normalization?

0 Answers  

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

0 Answers  

select empid empname from employee What is the result for the about query?

4 Answers  

What is transaction server auto commit?

0 Answers  

What are logical/boolean operations in ms sql server?

0 Answers  

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

IN Vs OR operator which is best to use sql server.

4 Answers  

Explain about remote stored procedure?

0 Answers