Answer / raghunath

select empno from emp group by empno having count(empno)>1;

it is working.

Answer / nagam

select count(*),empno from emp group by empno having count(*)>1;

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

What is a quality stage?

1 Answers  

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

0 Answers   IBM,

---

Highlight the main features of datastage?

0 Answers  

---

What are some different alternative commands associated with "dsjob"?

0 Answers  

---

How will you move hashed file from one location to another location?

0 Answers   NTT Data,

---

In one project how many shared containers are created?

3 Answers   NTT Data,

---

How to display all the duplicate records from the oracle Table?

3 Answers   IBM,

---

What are the different database update actions available?

1 Answers   HP,

---

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

---

how many types of sorting the data in data stage?

1 Answers   BoA, IBM,

---

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,

---

whom do you report?

0 Answers   NTT Data,

---