Mr. Chandran, I tried your query but the system is throwing error message

Write a query to delete duplicate records in SQL SERVER

Question Posted / pavan kumar

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

Please Help Members By Posting Answers For Below Questions

Explain about merge replications?

964

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2424

What is the difference between stored procedure and user defined functions?

1128

what is bit datatype? : Sql server database administration

864

How to recompile stored procedure at run time?

1005

Explain DBCC?

908

How many databases Microsoft SQL server provides?

1028

How to use transact-sql statements to access the database engine?

997

how to create “alternate row colour”?

142

What is cached report?

135

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1006

What are extended events in sql server?

903

Explain aggregate functions?

1027

What is the difference between dataadapter and datareader?

941

What is acid properties?

1019