首先 查询表fp_studentItem中的studentid=1;有5条数据,我只想要id=163的最新数据
两种方法:
1、SELECT * FROM fp_studentItem where id=( SELECT MAX(id) FROM fp_studentItem where studentid=1)
SELECT * FROM fp_studentItem where id=( SELECT MAX(id) FROM fp_studentItem where studentid=1)
子查询查询最大的id(不怎么推荐)
2、SELECT * FROM fp_studentItem WHERE studentid=1 ORDER BY id DESC LIMIT 1
SELECT * FROM fp_studentItem WHERE studentid=1 ORDER BY id DESC LIMIT 1
查询结果:
版权声明:本文为CSDN博主「jovi_zhao」的原创文章
原文链接:https://blog.csdn.net/jovi_zhao/article/details/82181095