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
- 14875 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's The Percentage Free Space ?
What is schema in db2?
What is universal database?
What are host variables in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Discuss about db2 bind?
What type of database is db2?
What is a db2 tablespace?
What is multi row fetch in db2?
How many databases can be created inside an instance in db2 ?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
How do you select a row using indexes in db2?
How many databases are there?
What are bind parameters in db2?
What is the max length of sqlca?
