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

What is the Difference beween sql server 2005 and sql server 2008

3 Answers   CMC, Hitech,

Psudo colums

1 Answers   HP,

What is nolock?

0 Answers  

What is excution Plan in sql server

1 Answers   CarrizalSoft Technologies, TCS,

hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn

0 Answers  

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

What is the security model used in sql server 2005?

0 Answers  

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 Answers  

Which are the olap features?

0 Answers  

Which sql server is best?

0 Answers  

Do you know what is sql service broker?

0 Answers  

Please tell me some knowledge about Clustering and how to add clustering?

1 Answers