group by 就不要想了。。。
sql 还有个partition by 东西
表结构如下
select * from (select ID,TextContext,UserWeiXinID,AgentID,EnterpriseInfoID,CreateDate,State,ROW_NUMBER() over(partition by UserWeiXinID,AgentID order by CreateDate desc) as new_index
from WX_TextContent) a
where a.new_index=1
取出某个人某个应用下最新的一条数据