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
What is ibm datastage flow designer?
what is flow of project?
What is active and passive stage?
Explain the importance of surrogate key in data warehousing?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How complex jobs are implemented in datstage to improve performance?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What could be a data source system?
Why fact table is in normal form?
options available in sequence job to run,validate?
What are the difference types of stages?
Differentiate between hash file and sequential file?
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?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
How do you schedule or monitoring the job?