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
- 13559 Views
- Amdocs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rama krishna reddy
b
if no matching records found then it will return null value
| Is This Answer Correct ? | 36 Yes | 3 No |
Answer / guest.
Lalit, I contradict your answe because the question itself
says that there is no matching record with
deptno='insurance'. So (b)is the correct answer.
| Is This Answer Correct ? | 20 Yes | 1 No |
Answer / pankaj
ans is a) ZERO
the anser is ZERO because there is no record in the table
they can shows the zero value present in the table
0 record is selected
message is disply
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / mr.perfect
error +100 we will get, record not found.......
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / swapnil
It depends up on the which database we are using. I m using
PostgreSQL it is in open source.It returns 0 value.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / lalit
Hi,
My understanding is different so it can be a or b. Assume
that there are 10 records and this column can have null
values. If 9 records have null and one record has vale as
zero then the answer would be zero and if all of them have
null then the answer would be null. If no rows satifies the
criteria then it would be null.
| Is This Answer Correct ? | 5 Yes | 7 No |
What is a db2 cursor?
Can we use select * statement in cobol program without giving field names ???
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
How does DB2 use multiple table indexes?
How do you find the maximum value in a column in db2?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
Which are the db2 tools to protect integrity of the database?
What do you mean by NOT NULL? When will you use it?
What are the three DB2 date and time data types and their associated functions?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
can you use symbolic parameters in JOB?
COBOL 
