09 2024 档案

mysql 常用

摘要：查询最新一条 SELECT t.* FROM your_table t INNER JOIN ( SELECT type, MAX(created_at) as latest FROM your_table GROUP BY type ) t2 ON t.type = t2.type AND t.c 阅读全文

posted @ 2024-09-06 09:24 酷盖的小机灵阅读(3) 评论(0) 推荐(0) 编辑

orcale 上一条，下一条

摘要：LAG(PUBLISHDATE, 1) OVER ( PARTITION BY b.FSYMBOL ORDER BY PUBLISHDATE) AS begin_date LEAD(PUBLISHDATE, 1) OVER ( PARTITION BY b.FSYMBOL ORDER BY PUBL 阅读全文

posted @ 2024-09-05 17:58 酷盖的小机灵阅读(8) 评论(0) 推荐(0) 编辑

mysql 排序函数

摘要：ROW_NUMBER() OVER ( PARTITION BY a.nav_date,b.level3id ORDER BY a.adjust_unit_nav asc) AS row_num 阅读全文

posted @ 2024-09-05 17:57 酷盖的小机灵阅读(4) 评论(0) 推荐(0) 编辑