06 2020 档案

row_number() over()函数和with as
摘要：做个笔记 row_number() over(partition by 分组列 order by 排序列 desc) SELECT * FROM (SELECT T.*, ROW_NUMBER() OVER(PARTITION BY T.deviceid ORDER BY T.itime DESC) 阅读全文
posted @ 2020-06-08 14:56 ZuiTaiPing 阅读(22) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示