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
- 16299 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / mr.perfect
error +100 we will get, record not found.......
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If I have a view which is a join of two or more tables, can this view be updateable?
What are types of indexes?
How can we retrieve the total number of records in RPG & CLLE?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What are db2 objects?
How to test SQL -911 error while developing COB-DB2 program
What is the difference between spufi and qmf?
When the like statement is used?
What is the use of db2?
How do I start db2 in windows?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is coalesce in db2?
Is db2 relational database?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
