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
- 16391 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / guest
NULL
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is a storage group (stogroup)?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is rebind in db2?
How to find schema of a table in db2?
What is lock escalation in db2?
What r the comman abends in db2, jcl and cobol???????
What are iseries servers?
What is the role of data manager in the db2 database?
What is cascading rollback?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What parameters are used to control the free space in DB2?
What is load replace in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is the maximum size of varchar data type in db2?
