Sunday, January 16, 2011

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
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)