MySQL 5.5 Community Server MySQL 5.6 Community Server Percona Configuration Wizard XtraBackup 搭建主从复制 Great Sites on MySQL Percona MySQL Performance Blog Severalnines 推荐管理工具 Sequel Pro phpMyAdmin 推荐书目 MySQL Cookbook
MySQL 相关项目 MariaDB Drizzle 参考文档 http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目 MariaDB Drizzle 参考文档 http://mysql-python.sourceforge.net/MySQLdb.html 
这是一个创建于 1046 天前的主题，其中的信息可能已经有所发展或是发生改变。
SELECT
MAX(oc2.CREATEDTIME ) OVER (PARTITION BY oc2.RENEWAL_FIRST_CON) ,oc2.CONTRACT_ID
FROM
OSR_CONTRACT oc2
INNER join
(SELECT CONTRACT_ID FROM OSR_CONTRACT oc WHERE oc.renewal_first_con IS NULL AND IS_RENEWAL = 'N') AS a
ON a.CONTRACT_ID=oc2.RENEWAL_FIRST_CON
想查出最大时间的这条合同 id 。用时间关联查询感觉不托。一时间想不到其他写法。sql 基本功差。
MAX(oc2.CREATEDTIME ) OVER (PARTITION BY oc2.RENEWAL_FIRST_CON) ,oc2.CONTRACT_ID
FROM
OSR_CONTRACT oc2
INNER join
(SELECT CONTRACT_ID FROM OSR_CONTRACT oc WHERE oc.renewal_first_con IS NULL AND IS_RENEWAL = 'N') AS a
ON a.CONTRACT_ID=oc2.RENEWAL_FIRST_CON
想查出最大时间的这条合同 id 。用时间关联查询感觉不托。一时间想不到其他写法。sql 基本功差。
 | 1 ffw5b7 OP 不妥…… |
| 2 ffw5b7 OP SELECT oc3.CONTRACT_ID from OSR_CONTRACT oc3 INNER JOIN ( SELECT MAX(oc2.CREATEDTIME ) AS CREATEDTIME FROM OSR_CONTRACT oc2 INNER join OSR_CONTRACT oc ON oc.CONTRACT_ID=oc2.RENEWAL_FIRST_CON WHERE oc.renewal_first_con IS NULL AND oc.IS_RENEWAL = 'N' GROUP BY oc2.RENEWAL_FIRST_CON ) AS a ON oc3.CREATEDTIME = a.CREATEDTIME 用时间关键感觉不妥 |
| 3 ffw5b7 OP 没有办法可能只能用时间关联先实现了。 |
| 4 ffw5b7 OP 就是分组后取每一组内最新的数据。 |
 | 5 xsonglive491 2023-02-08 16:15:40 +08:00 |
Select Language