Interested to Buy Any Domain ? << Click Here >> for more details...
How to display all the duplicate records from the oracle
Table?
- 3 Answers
- 10263 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nagam
select count(*),empno from emp group by empno having count(*)>1;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is datastage?
How we can covert server job to a parallel job?
What is the difference between validated and compiled in the datastage?
What is size of a transaction and an array means in a datastage?
AGGREGATOR default datatype
Name the command line functions to import and export the DS jobs?
How to reverse the string using unix?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
what is the difference between == and eq in UNIX shell scripting?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is datastage engine?
What is the difference between account and directory options ?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
