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
Can we write a distributed query and get some data which is located on other server and oracle database?
Explain how would you store your query in an SSRS report or a Database server?
What are diverse clauses that form a part of sql?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Why use “in” clause in sql server?
What is index in an assignment?
What is the dbcc command and why is it used?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
How do you make a trace?
What is resource governor?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What are the types of stored procedures in an sql server?
What are the properties of the transactions?
Do you know what are the restrictions that views have to follow?
How are the unique and primary key constraints different?