摘要: partition by:进行分组 ORDER BY:进行排序 row_number:统计行数 select a.* from ( select *, "row_number"() over (partition by hall_id,center_frequency ORDER BY last_d 阅读全文
posted @ 2021-08-13 17:44 wangssd 阅读(992) 评论(0) 推荐(0) 编辑