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
- 11156 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
what is the difference between Delete and Truncate command in SQL
What is the difference between varchar and nvarchar?
define and explain the differences between clustered and non-clustered indexes.
What is the latest version of microsoft sql server?
What are the requirements to use odbc connections in php scripts?
What are different types of schemas?
Why are sql functions used?
What is the use of custom fields in report?
Why are you getting errors when creating a new odbc dsn?
Can you please explain the difference between function and stored procedure?
What is cte (common table expression)?
How to download and install the scaled-down database adventureworkslt?
Explain what is lock escalation?
What is rtm version in sql server?
What is difference statement and preparedstatement?
