1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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?

Question Posted / ravindra_vemula

Answers were Sorted based on User's Feedback



I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LO..

Answer / nimsatprasad

Try this if wrong let me know...

SELECT A.NAME
,A.DEPTNAME
,B.DOJ
FROM EMP_TABLE A
,DEPT_TABLE.EMP_TABLE B
WHERE A.DEPTNO = B.DEPTNO
AND B.DOJ BETWEEN '01-01-2007' AND '01-01-2008'
;

Is This Answer Correct ?    14 Yes 2 No

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LO..

Answer / amlan roy

Select...........
from....
........
where DEPT_TABLE.DEPNO = EMP_TABLE.DEPNO.
AND DOJ between '01/01/2007' and '01/01/2008'

Is This Answer Correct ?    11 Yes 1 No

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LO..

Answer / harsha

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 ?    5 Yes 2 No

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LO..

Answer / arul

Select a.Name,a.DeptName,b.doj From Emp_Table as
a,Dept_Table as b Where a.Deptno=b.deptno and b.doj
between '01-jan-2007' And '01-jan-2008'

Is This Answer Correct ?    3 Yes 2 No

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LO..

Answer / 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

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LO..

Answer / 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

More DB2 Interview Questions

how to resolve -811 error. give clear explination

4 Answers   IBM,

What information is held in SYSIBM.SYSCOPY?

1 Answers  

What is host variable?

1 Answers  

Are views updateable?

1 Answers  

What is image copy in db2?

1 Answers  

What is the connection string to connect to the DB2 Database ?

1 Answers   MCN Solutions,

What is a Database Request Module(DBRM)?

4 Answers  

What is image copy?

1 Answers   Virtusa,

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

what are extents?

5 Answers  

What is syscat in db2?

1 Answers  

For more DB2 Interview Questions Click Here
Categories