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 many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

What is spid in sql server profiler?

0 Answers  

What are commonly used mssql functions in php?

0 Answers  

What is a trigger and types of a trigger?

0 Answers  

what are the limitations of parameters in a storedprocedure

1 Answers  

Define master database?

0 Answers  

How to change the password of a login name in ms sql server?

0 Answers  

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

0 Answers  

Which virtual table does a trigger use?

8 Answers   TCS,

What is trigger in salesforce?

0 Answers  

what are the disadvantages of cursors? : Sql server database administration

0 Answers