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

How to insert and update data into a table with "insert" and "update" statements?

0 Answers  

What is faster join or union?

0 Answers  

What are 3 ways to get a count of the number of records in a table?

0 Answers  

What is the difference between indexing and hashing?

0 Answers  

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

How to concatenate two character strings together?

0 Answers  

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers  

What part does database design plays a role in performance of an sql server-based application?

0 Answers  

How to write stored procedure to update the data in 10 tables

4 Answers  

How to perform backup for certificates in sql server? : sql server security

0 Answers