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
16161 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

What is the purpose of using commit?

1052

What is the physical storage length of time data type?

1085

What is dbrm? What it contains?

1125

What are the benefits of using the db2 database?

1176

What is copy pending and check pending in db2?

972

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1244

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1124

How can you do the explain of a dynamic sql statement?

1041

How to check last update on table in db2?

1020

How to rename a table in DB2 ?

1049

How do I delete a table in database?

996

What is an instance database?

1021

What are the uses of db2 optimizer?

1255

What is universal database?

1040

Explain about rct.

1042