Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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'

Answer Posted / guest

NULL

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by between and in? Is between inclusive of specified range values?

1057


Explain the function of data manager.

1010


What is the purpose of using commit?

1052


What is ibm db2 client?

900


Which component is responsible for db2 startup and shutdown?

999


How can we retrieve the total number of records in RPG & CLLE?

606


What are the full forms of spufi and dclgen and why are they used?

1035


Who uses db2?

1001


What are types of indexes?

1018


Which component is responsible for processing sql statements and selecting access paths?

1096


What are packages in db2?

990


What is db2 catalog database?

1000


How to check sequence on a table in db2?

1020


What is role in db2?

1059


What is performance tuning db2?

1025