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

Highlight the limitations of TPUMP Utility.

1111

What is the purpose of indexes?

1067

What happens when a node suffers a downfall?

1120

What is the difference between fastload and multiload? Which one is faster?

1214

How can bottlenecks be identified?

1009

What is a dimension table?

1054

What is stored procedure in teradata?

1020

Explain BYNET.

988

Explain the term 'primary key' related to relational database management system?

1026

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1192

Did you write stored procedures in teradata?

1128

What is the difference between union and union all in teradata?

1116

How can we check the version of Teradata that we are using currently?

1065

Explain teradata architecture?

1083

Explain teradata utilities. What is multiload, fast load, tpump?

1005