I’m try to make a query which returns the standard deviation of acolumn over JDBCas in Oracle:select stddev(col) from tableI get an error when I pass this to q. I know that I could use:q) select sd:dev col from tableWhich is the correct format when using a sql type query.Thanks.
To: personal-kdbplus@googlegroups.com
X-Mailer: Apple Mail (2.1084)
> select stddev(col) from table
>
> I get an error when I pass this to q. I know that I could use:
>
> q) select sd:dev col from table
there is no function named “stddev” in q, it’s “dev”
just do “select dev col from table” and you’ll get the standard =
deviation back in a column named “col”
(whether it’s over jdbc or not doesn’t matter)=
I’m sorry I didn’t make myself clear. My query which uses a standarddeviation aggregate callis just part of a much larger query that was written in standard SQLand I’d prefer not tore-write all the similar queries over to q. How do you call the devfunction in s?Thanks.On Nov 6, 12:26?am, Aaron Davies <aaron.dav…> wrote:> > select stddev(col) from table>> > I get an error when I pass this to q. ?I know that I could use:>> > q) select sd:dev col from table>> there is no function named “stddev” in q, it’s “dev”>> just do “select dev col from table” and you’ll get the standard deviation back in a column named “col”>> (whether it’s over jdbc or not doesn’t matter)</aaron.dav…>
To: personal-kdbplus@googlegroups.com
X-Mailer: Apple Mail (2.1251.1)
this is q, not standard sql plus standard functions. and most q users =
don’t care to much about standard sql in q context.
if you have queries that are using functions which you don’t want to =
change, write q “stored procedures/functions” to emulate them.
don’t count on kx or anybody else to do that for you.