Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / mathanrathinam

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

How do you size a resultset?

0 Answers  

what is raid? : Sql server database administration

0 Answers  

What is user defined datatypes and when you should go for them?

0 Answers  

What is the default order of an order by clause?

0 Answers  

Do you know concepts and capabilities of sql server?

0 Answers  

Explain isolation levels that sql server supports?

0 Answers  

What is nonclustered index on computed columns?

0 Answers  

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

Diffrent types of function

1 Answers   Wipro,

Describe in brief sql server monitoring ways.

0 Answers  

In which format does an image save in SQL Server database ?

0 Answers   MCN Solutions,

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories