Question

sql server 语句 查询数据库某个字段的最后一条数据

比如：A表里面的消费明细表，有工号、卡号、消费时间，我想查询每个人的最后一笔消费记录怎样查询！

Answer 1

select 工号、卡号、消费时间 from A
where 消费时间 in (select max(消费时间) FROM A group by 工号)

得到每个工号最后一条消费记录

Answer 2

select * from a where exists (select 1 from (select 工号,max(消费时间) as 消费时间 group by 工号) as b where a.工号=b.工号 and a.消费时间=b.消费时间)

Answer 3

select top 1 * from 消费明细表 where 工号=工号 order by 消费时间 desc

Answer 4

select gonghao,kahao,max(xiaofeishijian) from A group by gonghao order by kahao