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
- 13072 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
During the Display time, how is the sequence generated by Teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Syntax for case when statement?
How do you see a ddl for an existing table?
How you will check the version of teradata?
What are the main components of teradata system?
What are the joins in teradata and how many types of joins are there in teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
In general, how do you optimze any sql in teradata?
What is the maximum number of dml can be coded in a multiload script?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Explain teradata utilities. What is multiload, fast load, tpump?
What are the functions of a Parser?
What is a node in teradata?
