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
- 13464 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 does db2 stand for?
can we drop column from a table
What is runstats db2?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
What's The Error Code For Unique Index Voilation?
What's The Percentage Free Space ?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
How to fetch the last row from the table in SQL (db2)?
What is a DB2 access path?
Write a query to extract first 5 characters of a name in the column Stud_Name?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
COBOL 
