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
16701 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 node in db2?

1104

Which command is used to connect to a database in DB2 ? Give the Syntax.

1150

What are host variables in db2?

1122

What is the default page size of buffer pools?

1171

How is deadlock resolved?

1205

Who uses db2?

1112

How do we specify index to include or not during bind process.

2176

What are db2 objects?

1091

Why do chiropractors use drop table?

1164

What is package in db2 mainframe?

1037

What is data manager?

1103

Are views updateable?

1234

What is runstats db2?

1076

Is db2 relational database?

1044

What is the clustering index in the db2 database?

1047