It will be error, as we are using where with AVG function....we should use

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 / shailendra

10 Answers
16288 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

Please Help Members By Posting Answers For Below Questions

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3186

What is the function of logging in the db2 database?

1102

What is db2? Explain.

1015

What is ibm db2 connect?

974

What is an instance database?

1034

Why do we need reorg in db2?

968

Give a brief description of db2 isolation levels?

1047

Mention the definition of cobol in varchar field.

1225

How does a cursor work?

958

What is the maximum No of rows per page?

1052

What is cobol db2?

980

Where can you declare a cursor in a cobol-db2 program?

1055

Which component is responsible for processing sql statements and selecting access paths?

1113

What is database alias db2?

1105

What is check constraint in db2?

1062