how to delete duplicate rows from table in sql server

Answer Posted / swapna

We can delete duplicate rows from table by using distinct
command.

Is This Answer Correct ?    10 Yes 35 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the synonym of join?

523


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

563


How can we improve performance by using SQL Server profiler?

580


Is INSTEAD OF trigger directly applicable to Table ?

575


Difference between connected and disconnected database in .net with sql server?

579






What is the ‘fillfactor’?

568


How to create percentile function?

108


Explain about analysis services?

580


Do you know what guidelines should be followed to help minimize deadlocks?

538


What is transaction server auto commit?

579


what is the sql equivaent of the dataset relation object ?

1573


What stored by the master? : sql server database administration

581


How to execute function in stored procedure sql server?

543


What is an index in a database?

538


Why do we use trigger?

557