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 implement service broker?

0 Answers  

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

0 Answers  

---

Do you know data definition language, data control language and data manipulation language?

0 Answers  

---

Which TCP/IP port does SQL Server run on?

2 Answers  

---

What are the two authentication modes in sql server?

0 Answers  

---

---

what is the system function to get current user's user id? : Sql server database administration

0 Answers  

---

how do we find every fifth record in a table

14 Answers   Aspire, HCL,

---

How do I find the port number for sql server?

0 Answers  

---

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

0 Answers  

---

Can we join two tables without primary key?

0 Answers  

---

What are the extra roles available in msdb? : sql server security

0 Answers  

---

what is curser.

9 Answers  

---