
8 Aug
2014
8 Aug
'14
2:36 p.m.
Hi, it works as monetdb but does not as regular user. As a regular user I have to use sys.median .... Thanks On 08/08/2014 02:30 PM, Anthony Damico wrote:
create table test (a DOUBLE , b INT) ; INSERT INTO test (a , b) VALUES (0.1 , 0); INSERT INTO test (a, b) VALUES (1.1 , 1) ; INSERT INTO test (a, b) VALUES (2.1 , 2) ; SELECT MEDIAN( a ) , MEDIAN( b ) FROM test;