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
- 10947 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
When columns are added to existing tables, what do they initially contain?
What is difference between rownum and row_number?
Do you know what are the properties of the relational tables?
What is the name of reporting services config file and what’s it’s used for?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
How to execute stored procedure and set temp table in sql server?
Why use view instead of a table?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
what data regions are and what are the different data regions?
What does this statement do @@rowcount?
What are examples of triggers?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
How to Check if table exists in sql server?
How to create indexed view?
