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????
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 do you Generate sequence at the time of Display?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
how can we analyze the locks ?
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
What is the meaning of Caching in Teradata?
How can you track login parameters of users in teradata?
What is a three-tier data warehouse?
What are the various reporting tools in the market?
Can we load a Multi set table using MLOAD?
What is the primary index in teradata?
what is the difference between primary index and secondary index?.
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80