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
- 16363 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 schema the same as database?
How do I import data from excel to db2?
Explain in brief how does db2 determine what lock-size to use?
What is the connection string to connect to the DB2 Database ?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
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.
Can we delete records from view?
How do I add a column in db2?
What is the purpose of using commit?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How does cobol compile db2 program?
What is innodb buffer pool?
What happens in bind step in a db2 program?
List out the data types available.
What is the advantage in De-normalizing tables in DB2?
