delete from tab

Write a query to delete duplicate records in SQL SERVER

Question Posted / anil

Answer Posted / anil

delete from tab_nam where

Is This Answer Correct ?

2 Yes

30 No

Please Help Members By Posting Answers For Below Questions

How you can move data or databases between servers and databases in sql server?

1100

What is difference between joins and subqueries?

1171

Define tool Manage Statistics in SQL Server 2000 query ?

1166

How to find the login name linked to a given user name?

1059

Can a unique index be created on a column, which contains null?

968

How to write character string constants or literals in ms sql server?

1066

What is acid properties?

1190

How to replace null values in expressions using isnull()?

1152

How to execute stored procedure and set temp table in sql server?

1090

What are the types of processing and explain each? : sql server analysis services, ssas

1205

What is awe?

1078

Do you know what are acid properties?

1122

How to download microsoft sql server 2005 express edition?

1093

Define normalisation?

1155

Explain encryption of entire databases without the need for application changes in sql server 2008?

1090