Interested to Buy Any Domain ? << Click Here >> for more details...
How to handle nulls in Teradata???
How many columns can be there in a table???
How to find average sal with out using avg function????
- 3 Answers
- 13426 Views
- Mphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sri
without using "avg" we can find the avg salary by using sum
(sal)/count(sal);
sel sum(sal)/count(sal) as avgsal from tablename
regards,
sri
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / yuvaevergreen
1. Use zeroifnull,nullifzero in select and NULL in insert
directly.
2. 256 columns max per table.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / tdguy
1. use coalesce(column1,column2) or case when column1 is
nul...end or zeroifnull(column1) to handle nulls.
2. in TD 14.0 there can be 2048 columns per table.
3. sum/count gives you the average of the field.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to select first n records in teradata?
What are normalization, first normal form, second normal form and third normal form?
How can we load single row of data into teradata database. please give me the process.
What are the multiload utility limitations?
What do you mean by teradata intellicloud?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Explain the term 'columns' related to relational database management system?
Explain teradata architecture in detail with a diagram.
What is the purpose of joins in teradata?
How can bottlenecks be identified?
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.
What happens in a conflict? How do you handle that?
Teradata 
