How to display all the duplicate records from the oracle
Table?
Answer Posted / 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 |
Post New Answer View All Answers
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
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
What are the different kinds of views available in a datastage director?
what is the custome stage in datastage? how can we impliment that one? plz tell me
client know skid info?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Define ds designer?
Lookup constraints
what is 'reconsideration error' and how can i respond to this error and how to debug this
Define orabulk and bcp stages?
Why we use surrogate key?
What are the stages in datastage?
What is datastage engine?