Answer / sneha

select distinct * from table into new_table;

delete table;

select * from new_table into table;

Answer / cp

DELETE FROM emp WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM
emp GROUP BY empno)

Answer / smitha

;with empctc(empid,ename,sal,deptid,ranking)
as
(Select empid,ename,sal,deptid,ranking=Dense_rank() over (
partition by empid,ename,sal,deptid order by NEWID() asc)
from emp
)
delete * from empctc where ranking>1

Answer / sirisha

with numbered as(select rowno = row_number() over(partition
by empid order by empid),empname from employee)delete from
numbered where rowno > 1

Answer / pooja narang

We will get the duplicate records and insert them into a
new temp table by using below query:

select * into tmp_Employee
from Employee
having count(distinct *) > 1

Now delete the duplicate records from Employee table:

delete from Employee
having count(distinct *) > 1

Now insert the records from tmp_Employee to Employee table:

insert into Employee
select * from tmp_employee

drop table tmp_employee

explain the type of contraints

3 Answers  

How do you delete duplicate records in sql server?

0 Answers  

What is updatable resultset?

0 Answers  

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

What is normalization of database? What are its benefits?

0 Answers  

What language is sql server written in?

0 Answers  

List out a number of the wants to setup a SQL Server failover cluster?

0 Answers  

What are the types of subquery?

0 Answers  

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

0 Answers  

define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,

What are entities and relationships?

0 Answers  

What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,