How to delete duplicate rows from table except one?

Question Posted / shtakshi bhatnagar

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

More SQL Server Interview Questions

Explain what are various ways to enhance the ssrs report?

What are points to remember while using the fillfactor argument?

How to update muliple row in single query?

How to set database to be read_only in ms sql server?

What is transaction server consistency?

Do you know what is difference between stored procedure and user defined function?

When we should use and scope of @@identity?

If the job running very slow what is the action you do

What is built-in/administrator?

Can you roll back the ddl statement in a trigger?

Explain “row_number()” in sql server with an example?

Does table partitioning improve performance?

For more SQL Server Interview Questions Click Here