Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11086 Views
- Perot Systems, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
If I have a view which is a join of two or more tables, can this view be updateable?
How to fetch the last row from the table in SQL (db2)?
What is db2 plan table?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is a db2 cursor?
How to resolve -917 sql code in DB2?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
Highlight all the advantages that are attached to a package.
Explain the use of the WHERE clause.
What is role in db2?
Name the various locking levels available?
What is a DB2 access path?
COBOL 
