without using "avg" we can find the avg salary by using sum (sal

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????

Question Posted / sri

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

Please Help Members By Posting Answers For Below Questions

any one answer me how they can analyzing the project using data ware housing?

2487

What is multi insert?

1058

What is meant by a Highest Cost Plan?

1071

Explain the advantages of partitioned primary index in a query?

1029

Explain the parallel data extension in teradata?

1105

What are the different design perspectives used in teradata?

989

What is the difference between fastload and multiload?

1392

Where is teradata rdbms used?

1106

How do you define Teradata?

1041

Can we collect statistics on multiple columns?

1071

What do you mean by teradata intelliflex?

1115

What is the use of teradata system software?

1044

how can we analyze the locks ?

2137

What are the different table types supported by teradata?

978

Explain some differences between mpp and smp?

1109