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
- 13606 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 usage of open cursor command?
What does db2 stand for?
Can we delete records from view?
How to check sequence on a table in db2?
Highlight all the advantages that are attached to a package.
what is the sqlcode -501
What is the default page size of buffer pools?
How to test SQL -911 error while developing COB-DB2 program
What is the syntax for FETCH in DB2 ?
What is db2 and what is the use of db2 optimizer?
What is database manager in db2?
What is the latest version of ibm db2?
Are view updateable?
Explain dclgen.
What is the physical storage length of date data type?
