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

What is the purpose of linked server configuration in sql server?

1036

Do you know what are the properties of the relational tables?

1024

What is the temp table?

910

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

How to create a dynamic cursor with the dynamic option?

1040

What does normalization do to data?

1055

What is query optimization process?

1003

How to create a ddl trigger using "create trigger" statements?

1119

How does the report manager work in SSRS?

148

Write a SQL query in order to merge two different columns into single column?

1030

Write a query to find 5th highest amount paid from the customer table.

926

Define a cross join?

1001

How to view existing indexes on an given table using sys.indexes?

1085

What's the information that can be stored inside a bit column?

994

Explain time data type in sal server 2008?

918