选择最近的记录-MySQL php

Question

table 付款 schema

installment | remaining balance | date
----------------------------------------
6,000       | 50,000            | 03 March 2017 5:30 PM
10,000      | 40,000            | 04 March 2017 7:00 AM
3,000       | 37,000            | 08 March 2017 3:00 PM

我想选择最后一行的记录

3,000       | 37,000            | 08 March 2017 3:00 PM

我该如何在mysql中实现？

Answer 1

您可以使用ORDER BY和LIMIT为此，例如：

SELECT *
FROM payment 
ORDER BY date DESC LIMIT 1;