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
- 13292 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 |
What are the 5 phases in a multiload utility?
What is the use of having index on table?
Does SDLC changes when you use Teradata instead of Oracle?
Difference between inner join and outer join?
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
What are the joins in teradata and how many types of joins are there in teradata?
Which is faster fastload or multiload?
What is stored procedure in teradata?
What is oltp?
Explain the term 'primary key' related to relational database management system?
What is the Maximum number of volatile tables that can be created?
Define views in teradata with general syntax.
Teradata 
