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
- 13255 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How will you solve the problem that occurs during update?
If RDBMS is halted what will you do ?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is the use of virtual processor connectivity in teradata?
What are types of partition primary index (ppi) in teradata?
What are the things to be considered while creating secondary index?
What is meant by a Parsing Engine?
Explain and compare pros and cons of start schemas?
what is sysdba and sysdbc ? which has high priority ?
How to select first n records in teradata?
What is the difference between teradata and oracle?
Differentiate primary key and partition key?
Why do you get spool space errors? How do trouble-shoot them?
What are default access rights in teradata? What explicit right can be given to a user?
What are some primary characteristics of teradata?
