On 15-06-2008 18:23:05 -0700, Rt Ibmer wrote: > 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??
I think you're looking for "OFFSET 5000 LIMIT 1" ------------------------------------------------------------------------- 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
