answer is (a.) 0 0 recod selected.

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

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

Answer Posted / vinay

answer is

(a.) 0

0 recod selected.

Is This Answer Correct ?

7 Yes

19 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2942

Give a brief description of db2 isolation levels?

1074

What is the maximum length of sqlca?

1529

What is database manager in db2?

1023

Can we delete records from view?

967

What is the latest version of ibm db2?

1269

How do you pull up a query which was previously saved in qmf?

1151

What is phantom read in db2?

1161

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.

3211

What is db2 stogroup?

1160

Mention the definition of cobol in varchar field.

1250

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2066

What is data manager?

1050

What is the syntax for seeing the columns and data types of a table in the db2 database?

1169

What is the result of open cursor statement?

1083