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 Federation Root Database?
List the different normalization forms?
Explain the different types of backups available in sql server? : sql server database administration
What is hot add cpu in sql server 2008?
What is the difference between migration and upgradation in sql server?
How dts is used to extract, transform and consolidate data?
How do I setup a sql server database?
Mention the differences between having and where clause.
What is the command used to check locks in microsoft sql server?
Write a SQL query in order to merge two different columns into single column?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
When would you use a before or after trigger?
What are some examples of schemas?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How to insert new line characters into strings?