Re: Highest value from last n row
Posted by:
Rick James
Date: April 26, 2016 11:04PM
Or did you mean
select datetime, `64000005E5CBCD28`
from (
select datetime, `64000005E5CBCD28`
from my_table
order by datetime desc limit 100
) x
order by `64000005E5CBCD28` DESC LIMIT 1;
It would be good to have an index starting with `datetime`.
Subject
Written By
Posted
Re: Highest value from last n row
April 26, 2016 11:04PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.