如何获取最后插入3条记录条件mysql [英] How to get last inserted 3 records with condition mysql

问题描述

我为每个交易添加新记录（例如微型金融，今天客户支付300，然后新记录插入，明天500再次插入新记录）thyen如何获得基于客户ID的最后3条记录。 p>

am adding new record for every transaction( for ex; microfinance, today customer paid 300, then new record is inserted,tomorrow 500 again new record is inserted) thyen how can i get last 3 records based on customer id.

推荐答案

SELECT Id
      ,Password
      ,Amount
      ,@curRow := @curRow + 1 AS row_number
FROM sample JOIN  (SELECT @curRow := 0) r 
where id=1 
order by Row_number
desc limit 3;

这篇关于如何获取最后插入3条记录条件mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！