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
- 10295 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is node? How many nodes and amps used in your previous project?
In Teradata, what is the significance of UPSERT command?
What is spool space? Why do you get spool space errors?
Highlight the points of differences between the database and user in Teradata.
In the Primary Index, what is the score of AMPs that are actively involved?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What are the different functions performed in development phase?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is the use of virtual processor connectivity in teradata?
What is bteq utility in teradata?
If a Node is busy what are the steps you can take to avoid ?
Explain the types of join supports by teradata?
What are the functions involved in shared information architecture?
What is meant by Teradata Gateway?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
