Write a query to delete duplicate records in SQL SERVER
Answer Posted / abc
SELECT distinct column_names INTO temp_table FROM main_table
drop table main_table
sp_rename temp_table,main_table
| Is This Answer Correct ? | 19 Yes | 12 No |
Post New Answer View All Answers
How to enter unicode character string literals in ms sql server?
How can we rewrite sub-queries into simple select statements or with joins?
What is PROJECTION Operation?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What are the aggregate and scalar functions?
What stored by the msdb? : sql server database administration
Will sql server 2005 allow you to reduce the size of a column?
How do you send email on SQL Server?
What are the types of indexing?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What is postgresql server?
What are the advantages of using third-party tools?
How to generate create view script on an existing view?