Answer / varun

Select emp_id
from
employee
group by emp_id,dept
having count(*)>1;

Answer / krishnakumar

select employee-id
from table-name
grtoup by employee-id
having count(*) > 1

Answer / manikandan.d

hi all i hope this answer will help you


emp
eid ename dep
001 manikandan mainframe
002 karthi java
003 jarin mainframe
001 manikandan java
003 jarin testing
004 hariharan java
001 manikandan testing

select eid from emp e1 where 1 <

(select count(*) from emp e2 where e1.eid=e2.eid)

let me know if any new answer

Answer / venkat

select emp-id from emp group by emp-id having count(*)>1;

Answer / vish

Another classic example of people replying to the queries
in hurry..the answer #1, #2, #3, #4 & #7 are WRONG ANSWERS.
Answer #6 is correct. Answer #5 also seems to be correct to
me (unfortunatley I can't run & verify it at the moment,
someone please verify it & let everyone know).

Ram.g, FYI..EXISTS clause just denotes whether query after
EXISTS clause returned any row or not, it NEVER give a
count of the number of rows returned. Here need to find if
there are more than one rows (i.e count is needed) so
EXISTS can't be used here.

Answer / krishnakumar

Ans 5 is also correct but it seems a bit compliceted

Answer / sri

select A.empid from EMP A, EMP B where
A.empid = B.empid and
A.dept not = B.dept

Answer / ram.g

ans 5 need to be corrected...

subquery will fetch correct result but main query hw it
will compare... ???

it supposed to be where eid exists(select eid...where
e1.eid= e2.eid)

Answer / millar

select employee_id,department_id from emp where employee_id in(select employee_id from emp where department_id in (select distinct
department_id from emp) group by employee_id,department_id having count(*) >1);

Answer / anonymous

select emp_id from employee where dept in (select distinct
dept from employee) group by emp_id having count(*) >1;

What does the sqlcode of -818 pertain to?

3 Answers  

What is normalization and what are the five normal forms?

1 Answers  

Name the lockable units in DB2?

0 Answers  

How is deadlock resolved?

0 Answers  

What are the levels of isolation available with DB2V4

2 Answers   IBM,

What os does db2 run on?

0 Answers  

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

Mention the different locking levels that are available in db2.

0 Answers  

In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)

2 Answers  

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

What is a DB2 plan?

8 Answers  

What will the COMMIT accomplish?

5 Answers