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

What is the difference between upgrade and migration in sql server?

1166

How do I find the sql server version?

1096

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1284

Can one drop a column from a table?

1075

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1056

What is a scheduled job or what is a scheduled task?

1027

How do I find query history in sql server?

1014

Why use identity in sql server?

1185

Disadvantages of the indexes?

1213

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8218

What is normalization and what are the advantages of it?

1044

Can we do dml on views?

1027

Is it possible to have clustered index on separate drive from original table location?

1031

How to convert character strings into numeric values?

1175

How do I start sql server 2017?

1003