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 the cursor lock types?
What are the five major components of a dbms?
what are candidate key, alternate key and composite key? : Sql server database administration
what are different types of backups available in sql server? : Sql server database administration
What are the main differences between #temp tables and @table variables and which one is preferred?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What do you mean by tablesample?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What are user defined functions in ms sql server?
Explain the benefits of user-defined functions?
How to convert numeric expression data types by assignment operations?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
Explain atomicity?