How to remove duplicate rows from table except one?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is the use of keyword with encryption.

0 Answers  


What is an example of a foreign key?

0 Answers  


Do you know what are the ways available in sql server to execute sql statements?

0 Answers  


Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,


what operator performs pattern matching?

2 Answers  






What are the different types of triggers in SQL SERVER?

0 Answers  


what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  


What is the full form of dql?

0 Answers  


What is sub-query in sql server? Explain its properties.

0 Answers  


Explain few examples of stored procedure over triggers?

0 Answers   ADITI,


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  


What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,


Categories