如何查询购物表中所有客户的最后一次购买记录？

[itfly]

表结构
id khid gypz
1 1 2
2 1 3
3 1 2
4 1 3
5 2 1
6 2 2
7 3 2
我是想查询
凡是最后一次购买gypz=2的Khid是那些，这种SQL该怎么写？

[pengdali]

select * from 表 a where exists(select 1 from 表 group by khid having khid=a.khid and max(id)=a.id) and gypz=2

[8LY8Apollo]

select distinct khid from yourtable where gypz = 2