php - 如何选择 mysql 数据库中特定列的最后一个值？

Question

我当前正在使用此查询从发票编号不同的表中获取所有值。

SELECT * FROM  `selected_items` WHERE invoiceNo IN ( SELECT DISTINCT ( invoiceNo) AS invoiceNo FROM selected_items ) GROUP BY invoiceNo;

这是我的表结构

我想访问最后一行中的所有内容。我当前的查询给了我第一行。谢谢:)

Answer 1

使用order by rownum或GROUP BY

Select * From (
SELECT t.*, 
       @rownum := @rownum + 1 AS rank
  FROM selected_items t, 
       (SELECT @rownum := 0) r order by rank DESC
) si GROUP BY si.invoiceNo