select row_number() over(partition by column1 order by column2 desc

场景
定时任务，及定时任务结果两个表。
需要查询定时任务及最后一次执行结果数据

select t.task_id, t.task_name, t.task_desc,t.cron, t.task_status, b.task_result_status
        from dg_de_task t
        left join (select a.task_id, a.task_result_id, a.task_result_status 
        	from (select row_number() over(partition by task_id order by execution_time desc) as idx, res.* from dg_de_task_result res) a where a.idx = 1) b on t.task_id = b.task_id
        	

本栏目推荐文章
• antd中columns中配置的操作，如何，调用函数组件中的方法
• select row_number() over(partition by column1 order by column2 desc
• Kafka消费端抛出异常Offset commit cannot be completed since the consumer is not part of an active group for auto partition assignment; it is likely that the consumer was kicked out of the group的解决方案
• kendoui grid动态创建列Dynamic Columns
• 解决MySql： java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x8C\x9D\xF0\x9F...‘ for column
• Incorrect string value: '\xF0\x9F\x8D\xA6' for column 'NICK_NAME' at row 1
• Distinct 可以筛选多个 column
• Python - pandas 报错：ValueError: 'HIS_批准文号' is both an index level and a column label, which is ambiguous.
• 十八、组件-容器组件-column、row、flex
• 配置内核的时候提示Your display is too small to run Menuconfig! It must be at least 19 lines by 80 columns.

column row_number partition column1 column2column row_number partition column1 column2 column1 row_number partition number autoid row_number partition number order cmc-oracle row_number函数partition row_number函数partition number row_number rank dense_rank row_number函数 dense_rank dense rank row_number