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...

whether Nulls will be counted while doing average?
example: we have table column A with following values
A
--
5
Null
8
3

Now what is the average of A?

Answer Posted / tdguy

nulls will not be considered for averages.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of bynets in multi-node systems?

1035


List out all forms of LOCKS that are available in Teradata.

969


What is primary index and secondary index?

1028


There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1114


Explain teradata vs. Redshift?

1028


What is meant by a Channel Driver?

1250


Explain vproc in teradata?

1008


How to select first n records in teradata?

1109


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

989


What are the components used in smp and massively parallel processing (mpp) machines?

1058


Explain the term 'columns' related to relational database management system?

1072


what are the uses of fact table and dimension table in banking project?

4557


What are some primary characteristics of teradata?

1002


Differentiate database data and data warehouse data?

1121


What does sleep function does in fast load?

1144