SELECT * FROM TB a WHERE EXISTS(SELECT 1 FROM (SELECT id,TRANSACTION_ID,MAX([datetime])[datetime] FROM TB GROUP BY id,TRANSACTION_ID)b WHERE a.id=b.id AND a.[datetime]=b.[datetime] AND a.TRANSACTION_ID=b.TRANSACTION_ID)
select max(TRANSACTION_ID) from a group by name
27,581
社区成员
68,544
社区内容
加载中
试试用AI创作助手写篇文章吧