SQL中如何能查到最后一笔记录

select f. kehu, f.riqi , A.jine from ( select kehu, max(riqi) riqi from A group by kehu ) f, A where f.kehu = A.kehu and f.riqi = A.riqi 顺祝你2015幸福快乐。