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

How to update a field in SQL after ALTERING a row?

690


What is the language structure to add a record to a table?

581


How except clause is differs from not in clause?

538


Explain what are the basic functions for master, msdb, model, tempdb databases?

531


What are the dis_advantages of stored procedures, triggers, indexes?

1692






How the authentication mode can be changed?

610


How to automatically create a log when an exception is being received into SQL Server?

743


What command must you use to include the not null constraint after a table has already been created?

546


what is normalization? : Sql server database administration

536


What is star, snowflake and star flake schema? : sql server analysis services, ssas

665


How to identify current user in ssrs report?

242


What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

591


Using the customer, and order table in northwind database, please write a query to produce xml?

657


What is the full form of dql?

516


How to achieve Paging of records in SQL SERVER?

594