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 are the various kinds of the hash file?

0 Answers  

---

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,

---

Why we need datasets ratherthan sequential files?

5 Answers  

---

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,

---

What is difference between 8.1 , 8.5 and 9.1 ?

1 Answers   IBM,

---

How many types of hash files are there?

0 Answers  

---

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,

---

what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

2 Answers   Satyam,

---

How to find value from a column in a dataset?

0 Answers   TIAA CREF,

---

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,

---

What is a folder? Difference types of stages?

0 Answers  

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

0 Answers   Accenture,

---