Interested to Buy Any Domain ? << Click Here >> for more details...
how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 9733 Views
- ANZ, I also Faced
- E-Mail Answers
Answer Posted / pandu
To get the duplicate records in a table use the query
Select distinct(deptno) from emp;
reply any one to me am i correct.
| Is This Answer Correct ? | 2 Yes | 26 No |
Post New Answer View All Answers
How and when does the db2 enforces the unique key?
How do I copy a table in db2?
Who uses db2?
What is universal database?
What are iseries servers?
What is a db2 collection?
How to check last update on table in db2?
How do I change the column size in db2?
What is db2 plan table?
What type of database is db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What are the two types of logging in the db2 database? Explain them.
What are the different types of base tables?
What is reorg?
What are the bind parameters ibm db2?
