程序小白,最近面试,这道题貌似得分两个组,实在写不来啊,大佬们帮帮忙,送佛送到西,帮忙就直接写出来,别给我提示,有时候我看得懂,提示不一定懂。感谢各位
2条回答
- ht121907 2019-05-17 13:35关注
SELECT v.customer_name,v.oid FROM (
SELECT a.customer_name,a.oid FROM t_workflow_agent_policy a ORDER BY a.create_timestamp DESC
) as v GROUP BY v.customer_name类似于里面先按时间排序,然后在分组取出来第一个
解决 2无用