Interested to Buy Any Domain ? << Click Here >> for more details...
How to display all the duplicate records from the oracle
Table?
- 3 Answers
- 10262 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
Which warehouse using in your datawarehouse
What is a folder? Difference types of stages?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Distinguish between informatica & datastage. Which one would you choose and why?
What are the job parameters?
Highlight the main features of datastage?
How one source columns or rows to be loaded in to two different tables?
How to Remove Duplicate using SQL?
how to delete one row in target dataset
Describe the architecture of datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is the difference between informatica and datastage?
Define Routines and their types?
how to abort the job its matain duplicates?
What are transforms and what is the differenece between routines and transforms?
