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

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

Write down the syntax and an example for create, rename and delete index?

0 Answers  

What is excution Plan in sql server

1 Answers   CarrizalSoft Technologies, TCS,

What is the difference between osql and query analyzer?

0 Answers  

Define cross join in sql server joins?

0 Answers  

Are null values the same as that of zero or a blank space?

0 Answers  

Why I am getting this error when renaming a database in ms sql server?

0 Answers  

What are the two types of concurrency?

4 Answers  

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

Why is replication required on the sql server?

0 Answers  

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

0 Answers  

Explain indexed views?

0 Answers