I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER
DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION
AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT
TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01-
JAN-2007 TO 01-JAN-2008?
- 6 Answers
- 9361 Views
- Perot Systems, I also Faced
- E-Mail Answers
Answer Posted / s
select name.deptname.doj from emp_table innerjoin dept_table
on emp_table.deptno = dept_table.deptno
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Why do chiropractors use drop table?
What is phantom read in db2?
How can deadlocks be resolved?
Explain packages.
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 the purpose of using commit?
List some fields from sqlca?
What is cascading rollback?
What is cursor with hold option in db2?
How can you quickly find out the # of rows updated after an update statement?
What is the result of open cursor statement?
What is the difference between drop table and delete table?
How do I delete a table in db2?
Can we insert update delete in view?
Mention the location where the output received from explain statement is stored.
