How to display all the duplicate records from the oracle
Table?
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 are the types of containers?
what is 'reconsideration error' and how can i respond to this error and how to debug this
If you want to use a same piece of code in different jobs, how will you achieve this?
What is apt_config in datastage?
What are the components of ascential data stage?
How to clean the datastage repository?
What are routines in datastage? Enlist various types of routines.
Lookup constraints
What are the stages in datastage?
Explain the situation where you have applied SCD in your project?
What are the types of hashed files in data stage
Define orabulk and bcp stages?
root tree will find which is server job and which is parallel job?
What are the features of datastage flow designer?
Can you explain players in datastage?