Interested to Buy Any Domain ? << Click Here >> for more details...
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'
- 10 Answers
- 16170 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / guest.
Lalit, I contradict your answe because the question itself
says that there is no matching record with
deptno='insurance'. So (b)is the correct answer.
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
How to view db2 table structure?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Explain about open switch business continuity software?
How is a typical db2 batch pgm executed?
What is bind plan?
What is the use of db2?
what is the sqlcode -501
Mention the downsides of page level lock.
How do I optimize a query in db2?
What is a cursor in programming?
What is catalog database in db2?
What is an instance database?
What is a storage group (stogroup)?
What are the 2 sqlcodes that are returned?
