Interested to Buy Any Domain ? << Click Here >> for more details...
How to display all the duplicate records from the oracle
Table?
- 3 Answers
- 10009 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
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Nls stands for what in datastage?
How to Remove Duplicate using SQL?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is active and passive stage?
what is flow of project?
What is apt_config in datastage?
What is the purpose of pivot stage?
Can you explain players in datastage?
How do y read Sequential file from job control?
What are the repository tables in datastage?
How to read multiple files using a single datastage job if files have the same metadata?
CHANGE CAPTURE
What is the importance of the exception activity in datastage?
Differentiate between Join, Merge and Lookup stage?
