SQLite Forum

Bug: MSVC uses intrinsic versions of ceil and floor for floating-point modes precise and fast (diagnosed)
Login
Yes ! Thank you so much.

cl sqlite3.c -DSQLITE_ENABLE_MATH_FUNCTIONS  -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_API=__declspec(dllexport) -link -dll -out:sqlite3.dll


and this work on Python-3.10.0a3 / Windows 10 20H2

with 
  datas(criteria, qty) as( values ('a', 1) ,('a', 2) , ('a', 3), ('a', 4) ,('a', 5), ('b',1), ('b',3) )
  , intermed(criteria, squared) as (select criteria, power(qty-avg(qty) over (partition by criteria) , 2) from datas ) 

select criteria, sqrt(sum(squared)/count(*)) as stddev from intermed group by criteria