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
- 13532 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / shailendra
It will be error, as we are using where with AVG function....we should use having
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is the primary key a clustered index?
What is the syntax for creating a table in the db2 database?
what is the responsibility of the construction superintendent
What type of database is db2?
What is isolation level in db2?
What are the contents of a dclmgen?
What is bind in db2?
What are db2 objects?
What is the purpose of rollback and commit?
What is meant by dclgen?
How do I optimize a query in db2?
How do you select a row using indexes in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is dclgen in db2?
How many databases can be created inside an instance in db2 ?
