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
- 8956 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the design features involved in teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
What is meant by a Parsing Engine?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What do high confidence, low confidence and no confidence mean in explain plan?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the various reporting tools in the market?
What are the available join types in teradata?
What do you mean by teradata sql assistant?
What is the command in bteq to check for session settings ?
What are differences between teradata and ansi session modes in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What are the various indexes in teradata? Why are they preferred?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
