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
- 9317 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
What are db2 objects?
What is a cursor in programming?
How can you quickly find out the # of rows updated after an update statement?
What is isolation level in db2?
Mention the different locking levels that are available in db2.
What is check constraint in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Is ibm db2 free?
Which component is used to execute the sql statements?
How to execute stored procedure in db2 command editor?
Are view updateable?
What is temporal table in db2?
How do you eliminate duplicate values in db2?
What is deadlock in db2?
What does runstats do in db2?
