I am trying something as shown here.
As in this sql fiddle http://sqlfiddle.com/#!9/8d217/4 I created table
CREATE TABLE something (`some_column` int); INSERT INTO something (`some_column`) VALUES (10),(20),(30),(40),(50);
I am trying to find median value so following is the query
select some_column from something order by some_column limit 1 offset (select floor(count(some_column) / 2) from something);
MySQL complains about the query part after offset; and it does accept hard coded values like any integer instead of sub-query like
(select floor(count(some_column) / 2) from something).
I am guessing the offset expects to get hard coded value and not a column with a value. I did try other options like using variables
@ but cannot make it work.
My question is; if I want to use a value from query operation in offset or limit and not a hard coded value, how should I go about it?