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?
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
Write a program to show the parser component used in teradata?
What is the multi-insert?
What are default access rights in teradata?
What is spool space? Why do you get spool space errors?
What is the use of having index on table?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What is the purpose of using case expression in teradata?
Differentiate primary key and partition key?
Explain the term 'columns' related to relational database management system?
What are the steps involved in the process flow of the sql statement through channel attached system?
How would you load a very large file in teradata in general?
What is TPD?
List out teradata data types?
What is spool space?
How will you solve the problem that occurs during update?