img by Coba

Results tagged “average”

How to Find the Truncated Mean in SQL

The truncated mean is an average over a set obtained after you actually ignore the highest and lowest numbers. For example: given a set of the three numbers 100, 200 and 300, the "average" would be 200. We would add 100, 200, and 300 then divide by the number of...
1
authors
scott whigham
grant moyle
chad weaver
recent comments
  • Scott Whigham: Nice! I didn't even include it lol. It's funny how read more
  • Dinesh Asanka: Hi, Why can't you use following, Select fld1, (Sum(amt) - read more