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
- 10685 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
How do you migrate data from mssql server to azure?
Would you store your query in a ssrs report or a database server? State the reason why?
State a few properties of relational databases?
Name few of the dcl commands in sql?
Is the order of columns in the set clause important in ms sql server?
Do you know what are the ways available in sql server to execute sql statements?
What is the new security features added in sql server 2016? : sql server security
How many null values we can have in a unique key field in sql server?
What is a View ? Can we insert, Update and delete a view?
Write down the syntax and an example for create, rename and delete index?
Explain a join?
What is field with example?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
How to replace given values with null using nullif()?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
