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
- 10288 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 |
How do you determine the number of sessions?
Hash collision?
What is TPD?
What are the enhanced features in teradata v2r5 and v2r6?
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
Can we load a Multi set table using MLOAD?
What are the types of tables in Teradata
22 Answers Cap Gemini, Cognizant, Infosys,
What is teradata?
In general, how do you optimze any sql in teradata?
1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?
What is the use of upsert command in teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Teradata 
