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
- 10297 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / bkishor
Nulls are ignored in AVg Function.so the output will be 5+8+3/3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Why does varchar occupy 2 extra bytes?
What is spool space? Why do you get spool space errors?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is the meaning of Caching in Teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are the main components of teradata system?
What is the difference between global temporary tables and volatile temporary tables?
What are the available primary index types?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the joins in teradata?
During the Display time, how is the sequence generated by Teradata?
Explain teradata architecture?
What is a node in teradata? Explain
What tools would you use for that?
