How to delete the duplicate rows from a table in SQL Server ??
Answer Posted / himmat
delete from table name
having count(column name)>1
group by column name
| Is This Answer Correct ? | 15 Yes | 25 No |
Post New Answer View All Answers
Explain about Joins?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is sql server transaction log file?
How can i Relate Tables in SSIS
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Which are the important points to note when multilanguage data is stored in a table?
What are the options which must be set to allow the usage of optimistic models?
What is the difference between a function and a trigger?
Can you explain various data region available in ssrs with their use?
What is difference statement and preparedstatement?
What is the server name for sql management studio?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is database replication? What are the different types of replication you can set up in sql server?
What is msdb database? : SQL Server Architecture
What is log in sql server?