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
- 9359 Views
- Perot Systems, I also Faced
- E-Mail Answers
Answer Posted / ramesh
select e.name,e.deptname,d.doj from emp_table e,dept_table d
where e.deptno=d.deptno and doj between '01-jan-2007' and
'01-jan-2008';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to find the number of rows in a db2 table?
What is the difference between bind and rebind in db2?
What is a cursor in programming?
Is db2 a database?
How do you pull up a query which was previously saved in qmf?
What is null in db2?
What is consistency token in db2?
When reorg is used?
How do I import data from excel to db2?
Why do chiropractors use drop table?
What does db2 stand for?
Which components manage deadlocks in db2?
Can you use max on a char column?
What is cascading rollback?
What is dbrm? What it contains?
