Teradata Interview questions
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
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment