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?
- 5 Answers
- 10047 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
yes..as said above, nulls would be completely ignored while
calculating averages.
similarly, while counting that column alone, "sel count(a)"
will give you 3 ignoring null.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / maka
Null value can not be counted with aggregate functions.
count(*) count null.
Here result will be 5
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / bkishor
Nulls are ignored in AVg Function.so the output will be 5+8+3/3
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the diffrence between Multiload & Fastload interms of Performance?
what is sysdba and sysdbc ? which has high priority ?
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?
What are the different functions performed in development phase?
which option is used to restart the fast load script?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are differences between teradata and ansi session modes in teradata?
How will you solve the problem that occurs during update?
What is the default join strategy in Teradata???
Define views in teradata with syntax.
Can you load multiple data files for same target table using fastload?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Teradata 
