I have a bunch of rows that have a date and ping col, I want to grab the latest 288 rows, and get the max ping within that range?
You'd think this query would work, but it does not:
SELECT max(stresponse) FROM stats WHERE stshardid=31 ORDER BY stdate DESC LIMIT 288;
The max() just gets the overall max and ignores the LIMIT flag.
You'd think this query would work, but it does not:
SELECT max(stresponse) FROM stats WHERE stshardid=31 ORDER BY stdate DESC LIMIT 288;
The max() just gets the overall max and ignores the LIMIT flag.