Delete duplicate records from the table?(Table must have
unique id)
Answer Posted / naren
delete id from table where id in(select id from table having count(id)>1)
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is rtm version in sql server?
What are number line correlation administrators will use while working with a subquery?
optimization techinques
What is the sql profiler?
What do you understand by hotfixes and patches in sql server?
Explain why variables called the most powerful component of ssis?
Explain difference between control flow and data flow?
What do you know about normalization and de- normalization?
How to get a list all databases on the sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
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 to apply cascading referential integrity in place of triggers?
How to defragment indexes with alter index ... Reorganize?
Why it is recommended to avoid referencing a floating point column in the where clause?