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
- 24131 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / anonymous
select emp_id from employee where dept in (select distinct
dept from employee) group by emp_id having count(*) >1;
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the uses of db2 optimizer?
What is a db2 tablespace?
What is the use of db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is the physical storage length of time data type?
What is multi row fetch in db2?
Is db2 a mainframe?
What is the use of reorg in db2?
What is the role of data manager in the db2 database?
what is the sqlcode -501
What is db2 stogroup?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the purpose of using commit?
What does db2 stand for?
What is the physical storage length of the data types date, time, and timestamp?
