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 the difference between hashfile and sequential file?

0 Answers  

---

I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com

2 Answers   TCS,

---

What is the difference between an operational datastage and a data warehouse?

0 Answers  

---

How and where you used hash file?

0 Answers  

---

What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  

---

In merge stage can we update the values?

3 Answers   TCS,

---

Where do you see different stages in the designer?

0 Answers  

---

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers   TCS,

---

In one project how many shared containers are created?

3 Answers   NTT Data,

---

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

0 Answers   Wipro,

---

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---