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
- 16432 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / pankaj
ans is a) ZERO
the anser is ZERO because there is no record in the table
they can shows the zero value present in the table
0 record is selected
message is disply
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is null indicator in cobol db2?
What is an instance in db2?
What is a buffer in memory?
What is the maximum size of a char data type in db2?
Explain about open switch business continuity software?
Which is faster delete or truncate?
How do I add a column in db2?
How to find the number of rows in a db2 table?
What is cursor in dbms?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is database reorganization?
What is the role of the data page in the db2 database?
How does db2 sample database connect?
What is null in db2?
How would the varchar column remarks defined?
