在mysql查询中获取MAX值 [英] Get MAX value in mysql query

问题描述

我有一张桌子

       id     mid    userid    remarks
       1       2       8          7 
       2       2       8          6
       3       2       8          4 
       4       2       8          5
       5       2       8          2
       6       2       8          3
       7       2       8          7
       8       2       8          0
       9       2       8          1
       10      2       8          8

我需要在该行之前的最后一行备注.即备注"1"

I need the last row of remark before that row. i.e., remark '1'

SELECT MAX(id),mid,userid,remarks FROM sample 

推荐答案

Select Id,mid,userid,remarks from sample Where id<(select max(Id) from sample)
order by id desc limit 1

或

Select Id,mid,userid,remarks from sample 
order by id desc limit 1 offset 1

这篇关于在mysql查询中获取MAX值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！