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
- 13445 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
What is the purpose of using commit?
Which component is responsible for db2 startup and shutdown?
What is syscat in db2?
What is sqlca?
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.
What parameters are used to control the free space in DB2?
Before you give the explain statement, what are the prerogatives?
i want to maintain uniqueness on pdf without make lf??????????
What are the two types of logging in the db2 database? Explain them.
What is the syntax for creating a table in the db2 database?
How do I add a column to a table in db2?
What is drop table?
What is a db2 collection?
What is the difference between cursor and select statement?
How to fetch the last row from the table in SQL (db2)?
