16 Jun
2008
16 Jun
'08
1:23 a.m.
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.