Interested to Buy Any Domain ? << Click Here >> for more details...
In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
- 15 Answers
- 24142 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which command is used to connect to a database in DB2 ? Give the Syntax.
Which isolation level provides highest data integrity?
What is ibm db2 connect?
What is release/acquire in bind?
How to access db2 tables in mainframe?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How to restart a DB2 program?
How do I change the column size in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How can we read records for specific member in CL? AND rpg?
What is the difference between db2 and oracle?
Define sqlca.
How to compare data between two tables in db2?
Explain the function done by data manager?
What is a Foreign Key?
