How to display all the duplicate records from the oracle
Table?
Answers were Sorted based on User's Feedback
Answer / raghunath
select empno from emp group by empno having count(empno)>1;
it is working.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / nagam
select count(*),empno from emp group by empno having count(*)>1;
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prasad
select * from Table_name where column_name in(select Column_name from table_name group by column_name having count(1)>1)
select deptno from emp where deptno in (select deptno from emp group by deptno having count(1)>1)
u will get only duplicate records
for Example:
deptno
----------
10
10
20
20
30
40
50
by using above query the o/p displays
deptno
--------------
10
10
20
20
Is This Answer Correct ? | 0 Yes | 0 No |
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance
If you want to use a same piece of code in different jobs, how will you achieve this?
Define oconv () and iconv () functions in datastage?
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
Differentiate between operational datastage (ods) and data warehouse?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT