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
- 10046 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
Highlight the advantages of PPI(Partition Primary Index).
What is the purpose of joins in teradata?
Highlight the differences between Primary Key and Primary Index.
What are the available primary index types in teradata.
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Can we collect statistics on multiple columns?
Mention a few of the ETL tools that come under Teradata.
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Explain parsing engine in teradata?
Explain PDE.
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
if collect stats but it show low confidence why?
How do you create tables? Exact syntax, and create profiles, users in teradata?
How to Extract data from multiple legacy systems?
What are the scenarios in which full table scans occurs?
