Interested to Buy Any Domain ? << Click Here >> for more details...
how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 9913 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
What is a plan and package in db2?
What is the result of open cursor statement?
What is bind in db2?
What is dbrm in db2 database?
What is nvl in db2?
What is the syntax for creating a table in the db2 database?
What is copy pending status in db2?
What is the role of data manager in the db2 database?
Explain about open switch business continuity software?
Describe major components of db2?
How to check sequence on a table in db2?
What does db2 blu stand for?
What are the various isolation levels possible?
What is check constraint. Explain with example.
Which command is used to connect to a database in DB2 ? Give the Syntax.
