Delete duplicate rows without using rowid.





No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer



More SQL Server Interview Questions

How do use Having,Group by,Group function in SQL?

0 Answers  


Wht is Stuff in sql ser

2 Answers  


What is Left Outer Join?

2 Answers  


What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  


What is blocking and how would you troubleshoot it?

3 Answers   HCL,


hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  


How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,


What are constraints? Explain different types of constraints?

26 Answers   Wipro, Polaris, Kendriya Vidyalaya(Kvs), Emsang,


HOW TO RENAME A COLUMN NAME

3 Answers  


What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

2 Answers   Apollo,


how to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,





Categories