ANSWER IS B. IT GIVES NULL.

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'

Question Posted / varalakshmi

10 Answers
16018 Views
Amdocs, I also Faced
E-Mail Answers

Answer Posted / varalakshmi

ANSWER IS B. IT GIVES NULL.

Is This Answer Correct ?

20 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is db2 a programming language?

982

What is a collection in db2?

982

What's The Percentage Free Space ?

1157

What is db2 look?

970

What is access path in db2?

923

How can we read records for specific member in CL? AND rpg?

643

Explain the contention situations caused by locks?

1012

What is page size in db2?

906

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1017

What is db2 command?

962

How is deadlock resolved?

1080

How to execute stored procedure in db2 command editor?

983

How to retrieve rows from a db2 table in embedded sql?

1325

What is package in cobol db2?

1075

What is cascading rollback?

1133