In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
Answer Posted / g.kameswara reddy
select employee_id from employee table where department in
('a1','a2','b1','b2');
| Is This Answer Correct ? | 7 Yes | 11 No |
Post New Answer View All Answers
Why do chiropractors use drop table?
Can we insert update delete in view?
Define check constraint.
Which isolation level provides maximum concurrency?
What is the picture clause of null indicator variable?
How to compare data between two tables in db2?
Explain packages.
What is load utility in db2?
What is null indicator in cobol db2?
Can one database have multiple instances?
How to find the number of rows in a db2 table?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is db2 connect?
What is with ur in db2?
What are the two types of logging in the db2 database? Explain them.