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
- 11084 Views
- Perot Systems, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can you find out the # of rows updated after an update statement?
What is node in db2?
Mention the different locking levels that are available in db2.
What is the usage of open cursor command?
Is schema the same as database?
Explain the contents that are a part of dclgen.
What is the purpose of using commit?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
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?
Explain how can you do the explain of a dynamic sql statement?
How will you return the number of records in table?
Explain about rct.
What is the use of db2?
Explain the function done by data manager?
