How do you delete duplicate rows in sql server?


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

Post New Answer

More SQL Server Interview Questions

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,


how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  


wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,


Explain the categories of stored procedure?

0 Answers  


in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  






What is the default order of an order by clause?

0 Answers  


What do I need to start working with sql studio? : sql server management studio

0 Answers  


how to implement locking in sql server

3 Answers   Satyam,


how we can use a database with php.

2 Answers   HCL, IT Solution,


What is the full form of ddl?

0 Answers  


Explain logical operators in sql server?

0 Answers  


Give main differences between "Truncate" and "Delete".

0 Answers   HCL,


Categories