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

How to select first n records in teradata?

1041


What is the difference between fastload and multiload? Which one is faster?

1146


Can we collect statistics on table level?

990


How to load specific no.of records using bteq, or fastload,or multiload

1693


How to find duplicates in a table?

1135


How can you track login parameters of users in teradata?

1126


What is the use of having index on table?

954


Syntax for case when statement?

1010


What is partitioned primary index (ppi)?

1000


How teradata makes sure that there are no duplicate rows being inserted when its a set table?

928


What is meant by a Channel Driver?

1142


What is spool space?

1075


What are the functions of a Parser?

1031


Explain BYNET.

948


How many types of joins are there in teradata?

915