摘要:
创建表 CREATE TABLE `dept` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `deptName` VARCHAR(30) DEFAULT NULL, `address` VARCHAR(40) DEFAULT NULL, ceo INT NULL 阅读全文
摘要:
1、最近连续失败5次的sql SELECT INTERFACE_NAME, COUNT(*) AS fail_count FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY INTERFACE_NAME ORDER BY REQUEST_TIME DES 阅读全文