Interested to Buy Any Domain ? << Click Here >> for more details...
what will be the output of the below given query, if no
matching records are found : (a.) 0 (b.) null (c.) error
select Avg(salary)
from TableA
where Deptno = 'insurance'
- 10 Answers
- 16396 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / mr.perfect
error +100 we will get, record not found.......
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of rollback and commit?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What are db2 objects?
Comment whether the cursor is closed during commit or not.
What is rebind in db2?
How do I change the column size in db2?
Mention the various locks that are available in db2.
What is phantom read in db2?
What is dclgen in db2?
What is commit in db2?
B37 abend during spufi?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How to restart a DB2 program?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Before you give the explain statement, what are the prerogatives?
