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
- 13077 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 view every column and the columns contained in indexes in teradata?
What is the difference between global temporary tables and volatile temporary tables?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
How can we load single row of data into teradata database. please give me the process.
Where we use PPI in real time??? What is the disadvantages of PPI?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Explain the term 'primary key' related to relational database management system?
What are the available primary index types in teradata.
what is the difference between primary index and secondary index?.
Name the five phases that come under MultiLoad Utility.
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Teradata 
