rbiswas4 · January 8, 2018 16:49
diff --git a/sqlite_variance b/sqlite_variance
 # sqlite has no function like std or var. This is a method of how it can be calculated
 # assume we want to get the variance of the column fieldRA from the table Summary in a sqlite DB. In this case the following produces the variance
 SELECT avg((SUMMARY.fieldRA - sub.a)*(SUMMARY.fieldRA - sub.a)) FROM Summary, (SELECT avg(fieldRA) as a FROM SUMMARY) AS sub;
	# sqlite has no function like std or var. This is a method of how it can be calculated
	# assume we want to get the variance of the column fieldRA from the table Summary in a sqlite DB. In this case the following produces the variance
	SELECT avg((SUMMARY.fieldRA - sub.a)*(SUMMARY.fieldRA - sub.a)) FROM Summary, (SELECT avg(fieldRA) as a FROM SUMMARY) AS sub;