Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all)
- 5 Answers
- 10914 Views
- Infosys, McAfee, I also Faced
- E-Mail Answers
Answer Posted / cp
DELETE FROM emp WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM
emp GROUP BY empno)
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Mention the different authentication modes in sql server.
How can you check the version of sql server?
Do you know what are the ways available in sql server to execute sql statements?
What is clustered vs nonclustered index?
Can we do dml on views?
Explain the categories of stored procedure?
Define model database?
do you know how to configure db2 side of the application? : Sql server database administration
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is checkpoint in sql server?
how many no of arguments can be passed in procedures and functions
How do use Having,Group by,Group function in SQL?
what is bit datatype? : Sql server database administration
Show Practically Sql Server Views are updatable?
Explain features of analysis services?
