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
- 13110 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 is identity columns in teradata
What is the use of fallback?
What are the different design perspectives used in teradata?
In general, how do you optimze any sql in teradata?
How to Extract data from multiple legacy systems?
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
Explain PDE.
what is identity columns in TD?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What are the components used in smp and massively parallel processing (mpp) machines?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Teradata 
