Teradata Material
Pages
Home
INFORMATICA
Fall Back,Journals and NODES
FASTLOAD
BTEQ
Teradata SQL
INDEXES
Teradata Architecture
MULTILOAD
CONTUCT US
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment