delete from tab

Write a query to delete duplicate records in SQL SERVER

Question Posted / anil

Answer Posted / anil

delete from tab_nam where

Is This Answer Correct ?

2 Yes

30 No

Please Help Members By Posting Answers For Below Questions

Distinguish between commit and rollback?

901

What is the difference between Clustered and Non-Clustered Index?

1014

Does windows server 2016 come with sql server?

881

What is compound operators?

978

What is self join in sql server joins?

966

How to create a scrollable cursor with the scroll option?

928

How do you delete duplicate rows in sql server?

901

What is data compression?

943

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

880

Define the one-to-one relationship while designing tables.

858

What do you mean by 'normalization'?

1008

What are the advantages of having an index on the sql server?

874

what's the difference between delete table and truncate table commands? : Sql server database administration

923

What is a performance monitor?

923

What is use of except clause?

1036