How to display all the duplicate records from the oracle
Table?
- 3 Answers
- 8731 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / raghunath
select empno from emp group by empno having count(empno)>1;
it is working.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Differentiate between validated and Compiled in the Datastage?
What is the difference between orabulk and bcp stages?
What can we do with datastage director?
what is repositery?
Is the value of staging variable stored temporarily or permanently?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How to Remove Duplicate using SQL?
What are the areas of application?
Distinguish between informatica & datastage. Which one would you choose and why?
what is ds administrator used for?
What is ds designer?
How can you write parallel routines in datastage PX?
Explain datastage architecture?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
