Write a query to delete duplicate records in SQL SERVER
Answer Posted / anil
delete from tab_nam where
| Is This Answer Correct ? | 2 Yes | 30 No |
Post New Answer View All Answers
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is the process of normalising?
How to create a simple user defined function in ms sql server?
What are sql server procedures?
What is row_number () and partition by in sql server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
How to Sync Two SQL Azure Databases?
what information is maintained within the msdb database? : Sql server administration
How to implement service broker?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What do you mean by a Composite primary key?
What is difference between index seek vs. Index scan?
What is the difference between function and stored procedure in sql server?
How to find the source of a table in sql server?
What are date and time data types in ms sql server?