如何找到我的查询的第二个最大值

Question

Here is my SQL query to find a row in currency_price table grouped by maximum date of inserting to table. My question is how to find the second maximum. I mean how can I change this query to find the second maximum row in each group:

select currency_id,buy,sell 
from (select * from currency_price  order by `currency_id`, cu_date desc,buy,sell) x 
group by `currency_id`

with this query i found a row for each id so for example i have sell and buy for each id .exm:

id    sell buy
1000  500  480
1001  20   19
...

but here i want the second maximum date for each id.

I know some query to find second maximum but all does not take me to my answer.

Answer 1

If it is MySql then Use LIMIT 1,1; # Retrieve rows [start with rec]1-[fetch rec count]1

http://dev.mysql.com/doc/refman/5.7/en/select.html