Friday, 7 March 2014

How to find average sal with out using avg function?


How to find average sal with out using avg function?

Answer

Without using "avg" we can find the avg salary by using sum (sal)/count (sal);
sel sum(sal)/count(sal) as avgsal from tablename

No comments:

Post a Comment