Write a query to delete duplicate records in SQL SERVER

Answer Posted / anil

delete from tab_nam where

Is This Answer Correct ?    2 Yes 30 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Will count(column) include columns with null values in its count?

744


Tell me what is the significance of null value and why should we avoid permitting null values?

613


Is sql server free?

598


what is raid and what are different types of raid configurations? : Sql server database administration

624


How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

122






Where do you find the default Index fill factor and how to change it?

681


what are defaults? : Sql server database administration

597


Can you please explain the difference between function and stored procedure?

627


Do you know how to send email from database?

630


What is the cartesian product of the table?

642


How many triggers you can have on a table?

609


What are the ways available in sql server to execute sql statements?

675


optimization techinques

2286


Does the order of columns in update statements matter?

578


Do you know sql server 2008 backup compression?

654