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

Steps to create a data model?

666

What is smp and mpp platforms?

531

What are normalization, first normal form, second normal form and third normal form?

636

What is inner join and outer join?

620

What are default access rights in teradata? What explicit right can be given to a user?

656

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

552

What is the purpose of using case expression in teradata?

577

Explain and compare pros and cons of snow flake schemas?

613

Explain the parallel data extension in teradata?

662

How to Extract data from multiple legacy systems?

576

If a Node is busy what are the steps you can take to avoid ?

1875

Explain and compare pros and cons of start schemas?

551

Explain parsing engine in teradata?

595

What are tpump utility limitations?

602

What type of indexing mechanism do we need to use for a typical data warehouse?

623