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

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1181

How to enter binary string literals in ms sql server?

1140

How does Report Builder support Analysis Services cubes?

153

How do I view a trc file?

931

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

1146

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1116

A trigger can reference objects outside the current database? State true or false.

999

What are the built in functions in sql server?

968

What are different types of views?

939

How to enter unicode character string literals in ms sql server?

1057

How you can minimize the deadlock situation?

1031

what is bit datatype? : Sql server database administration

904

What do you mean by SQL injection attack?

1047

What is buffer cash and log cache in sql server?

1106

Explain the use of containers in ssis and also their types?

960