Pour activer la fonction MEDIAN sous #SQLite
se rendre sur http://www.sqlite.org/contrib/download/ et télécharger extension-functions.c ; compiler :
# gcc -g -fPIC -dynamiclib extension-functions.c -o extension-functions.dylib
dans SQLite charger l’extension :
sqlite> .load extension-functions.dylib
utiliser :
sqlite> select MEDIAN(x) WHERE y…
fournit les fonctions :
Math: acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi.
String: replicate, charindex, leftstr, rightstr, ltrim, rtrim, trim, replace, reverse, proper, padl, padr, padc, strfilter.
Aggregate: stdev, variance, mode, median, lower_quartile, upper_quartile.
