b if no matching records found then it will return null value

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 / rama krishna reddy

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

Answer Posted / rama krishna reddy

b

if no matching records found then it will return null value

Is This Answer Correct ?

36 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about rct in db2?

1109

What r the comman abends in db2, jcl and cobol???????

2254

Mention the definition of cobol in varchar field.

1250

What is the usage of open cursor command?

1100

What is buffer pool and list some of them?

1028

Why db2 is called db2?

1044

What is a collection in db2?

1036

Explain db2.

1039

What is runstats db2?

1037

Explain about rct.

1090

What are the different types of base tables?

1096

What is db2 instance?

1102

What are the rules for db2 programming?

1091

Give the name of some fields form sqlca.

1086

What is a Foreign Key?

1099