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
- 10041 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
What is the maximum number of dml can be coded in a multiload script?
What is spool space? Why do you get spool space errors?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Explain the term 'primary key' related to relational database management system?
What are differences between teradata and ansi session modes in teradata?
How many tables can you join in v2r5?
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 are aggregate tables? How do you design them using teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is the meaning of Caching in Teradata?
What is the multi-insert?
Explain the most common data types used in teradata?
How to find duplicates in a table?
What are normalization, first normal form, second normal form and third normal form?
Explain teradata utilities. What is multiload, fast load, tpump?
