To get a median I want to use this:
select myIntCol from mytable order by myIntCol limit half_table_size,1;
This works in mySQL. However I get an error when I use limit with x,y params.
If I just use limit x then it limits the return results to just x rows. But
what I need to do is tell it to start with row x and only give me 1 row (i.e.
"... limit 5000, 1;" when I have 10000 rows in the table.
Does MonetDB support this format? If not is there a work around??
Thanks.
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
