Write a query to delete duplicate records in SQL SERVER
Answer Posted / subrata paul
Delete TOP(1)from example where[ID]=1
| Is This Answer Correct ? | 4 Yes | 10 No |
Post New Answer View All Answers
What is the language structure to add a record to a table?
What is always encrypted?
How can you manage sql azure security?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
How extra digits are handled with numeric data type literals?
Mention the uses of stored procedures.
How to get @@error and @@rowcount at the same time?
Explain encryption of entire databases without the need for application changes in sql server 2008?
How to disable a login name in ms sql server?
What is scan table/view and seek table/view when its occurs? : sql server database administration
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What are the differences between clustered and non-clustered index?
Explain what are the restrictions while creating batches in sql server?
Can you explain what are commit and rollback in sql?