write a query to remove duplicate records without using primary key column?

Question Posted / mathanrathinam

2 Answers
9370 Views
ABCO, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write a query to remove duplicate records without using primary key column?..

Answer / 312

351

Is This Answer Correct ?

3 Yes

3 No

write a query to remove duplicate records without using primary key column?..

Answer / mathanrathinam

delete tmp from(select col1,col2,row_number over(partition by col1,col2 order by col1,col2) rownum from tablename) tmp
where rownum >1

Is This Answer Correct ?

7 Yes

8 No

Post New Answer

More SQL Server Interview Questions

If user is owning any SQL Objects, can we drop that user

0 Answers

What are the advantages of policy management?

0 Answers

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 Answers

What is the Difference beween sql server 2005 and sql server 2008

3 Answers CMC, Hitech,

What are the options which must be set to allow the usage of optimistic models?

0 Answers

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

0 Answers Crown Solutions,

About DTS usage ?

2 Answers Cognizant, Wipro,

How to know whether our backup is succesfully taken?

1 Answers

What are different types of database indexes?

0 Answers

what is the disadvantage of SQL Loder?

1 Answers TCS,

Can some one please help with a query which will take only max value of a column in a join.

2 Answers

Selet all the data from table where last name is n of employee

2 Answers

For more SQL Server Interview Questions Click Here