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

Explain the term 'tables' related to relational database management system?

596

What are the updated features of teradata?

582

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

622

What is the basic syntax for teradata select statement?

578

Explain some differences between mpp and smp?

592

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3912

What are the functions performed by bynet?

611

if collect stats but it show low confidence why?

1190

How can you track login parameters of users in teradata?

633

What is a node in teradata? Explain

603

Explain teradata architecture?

634

What are the frequently used data types in teradata?

602

What is a sparse index?

632

What is oltp?

569

What does sleep function does in fast load?

620