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
- 16431 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / varalakshmi
ANSWER IS B. IT GIVES NULL.
| Is This Answer Correct ? | 20 Yes | 4 No |
Post New Answer View All Answers
What is page size in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How to view db2 table structure?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is ibm db2 client?
What is db2 catalog database?
What is load utility in db2?
How to create db2 table in mainframe?
What is null indicator in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Explain about rct in db2?
What is sqlca’s maximum length?
Is the primary key a clustered index?
Which isolation level provides maximum concurrency?
Mention the different locking levels that are available in db2.
