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
How to encrypt Strored Procedure in SQL SERVER?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Different types of keys in SQL?
Would you store your query in a ssrs report or a database server? State the reason why?
How to download and install the scaled-down database adventureworkslt?
Do you know how to make remote connection in database?
Do you know what is a trace frag? Where do we use it?
What are the benefits of normalization?
What is the recommended total size of your memory optimized tables?
What is a cube? : sql server analysis services, ssas
What is sqlservr.exe - process - sql server (sqlex?press)?
What is transact-sql ddl trigger?
Can you move the resources after pausing the node? : sql server database administration
Why would you use sql agent?
Can a synonym name of a table be used instead of a table name in a select statement?