Write a query to delete duplicate records in SQL SERVER

Answer Posted / pavan kumar

Mr. Chandran, I tried your query but the system is throwing
error message as 'Incorrect syntax near the
keyword 'group''.

Is This Answer Correct ?    28 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of nvl work?

565


What is the purpose of a table?

524


How do you delete a data source?

548


can you implement data mining in SSRS?

113


How to check if a table is being used in sql server?

517






How do you implement session management in SQL Server mode?

559


What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

534


What purpose does the model database server?

657


What is PROJECTION Operation?

611


Explain cursor as data base object?

578


Explain the stored procedure?

640


What are secondary xml indexes?

570


What are the different types of triggers in SQL SERVER?

541


What are two difference between sql azure and azure tables?

137


Can the query output be sorted by multiple columns in ms sql server?

554