Teradata Material
Pages
(Move to ...)
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
‹
›
Home
View web version
No comments:
Post a Comment