finding Median query in MySQL, help regarding limit keyword

Asked Jul 10 '19 at 05:51

Active Jul 10 '19 at 05:57

Viewed 20 times

-1

We need to find median query in a database in MySQL.

I wrote the query:

SET @MED=ROUND((SELECT COUNT(*) FROM STATION)/2,0) ;
SELECT @MED;
SELECT LAT_N, LONG_W FROM STATION LIMIT @MED,1;

My med holds some value but this error is popping up:

ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@MED,1' at line 1

edited Jul 10 '19 at 05:57

Arulkumar

12,153
12
44
61

asked Jul 10 '19 at 05:51

schwifty

The `LIMIT` parameter has to be a literal, it can't be a variable. – Barmar Jul 10 '19 at 05:56
thanks @Barmar , is there any other way to assign that variable to limit ? – schwifty Jul 10 '19 at 05:57
See the linked question it shows lots of ways to get the median. – Barmar Jul 10 '19 at 06:00

finding Median query in MySQL, help regarding limit keyword

0 Answers0