Interested to Buy Any Domain ? << Click Here >> for more details...
how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 9956 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
Explain various types of locks in db2?
Mention the various locks that are available in db2.
Who uses db2?
What is db2 command?
How many types of page locks can be held in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is db2 and what is the use of db2 optimizer?
What is dbrm? What it contains?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
List out the buffer pools in db2
What are catalog tables in db2?
How does cobol compile db2 program?
What are the prerogatives?
What is dbrm library?
What is the usage of open cursor command?
