11 2015 档案

MYSQL-实现sqlserver- row_number() over(partition by order by) 分组排序功能
摘要：sqlserver:with Result as ( select SUM(F_DayValue) AS F_Value,F_ZZ_ttBuildID,F_EnergyItemCode from T_EC_EnergyItemDayResult ... 阅读全文
posted @ 2015-11-18 11:59 代码咸鱼梦 阅读(2075) 评论(0) 推荐(0)
Sql Server 中 PIVOT在mysql 中的实现
摘要：sql server 中项目代码：select isnull(MI线,0) as F_MIValue,isnull(SMT线,0) as F_SMTValue,isnull(空压站,0) as F_ChangePre, isnull(Repair线,0) as F_RepairValu... 阅读全文
posted @ 2015-11-18 09:55 代码咸鱼梦 阅读(4403) 评论(0) 推荐(0)
MSSQL中 ROW_NUMBER() OVER(PARTITION BY COLUMN ORDER BY COLUMN)在Mysql中的实现
摘要：之前的MS SQL 中存储过程有下面一段代码：with rowvalue as ( SELECT ROW_NUMBER() OVER (ORDER BY F_WarnName DESC) AS id, F_PID,F_... 阅读全文
posted @ 2015-11-12 10:56 代码咸鱼梦 阅读(1212) 评论(0) 推荐(0)
mysql判断表中符合条件的记录是否存在
摘要：IF EXISTS( SELECT 1 FROM T_BD_BuildGroupBaseInfo WHERE F_BuildGroupID=P_StructureId LIMIT 1) THEN SET V_isBuildingGroup=1;ELSE SET V_isBuildingG... 阅读全文
posted @ 2015-11-09 10:59 代码咸鱼梦 阅读(12741) 评论(0) 推荐(1)
mysql对树进行递归查询
摘要：在进行数据库移植的过程中，遇到了对树进行递归查询的问题。在SQL server 中，很容易实现。如下图：WITH TreeAS (SELECT T1.F_EnergyItemCode FROM T_DT_EnergyItemDict AS T1 WHERE T1.F_EnergyItemCode =... 阅读全文
posted @ 2015-11-05 13:59 代码咸鱼梦 阅读(17259) 评论(0) 推荐(0)