0
推荐
1132
阅读
MYSQL 创建触发器
DROP TRIGGER IF EXISTS TRI_BAS_MEMBER_LEASE_ORG_D_I;DELIMITER $CREATE TRIGGER FDP.TRI_BAS_MEMBER_LEASE_ORG_D_I AFTER INSERT ON FDP.BAS_MEMBER_LEASE_ORG_D FOR EACH ROWBEGIN DECLARE ORG_TYPE_COPY CHAR(1); SET ORG_TYPE_COPY = (S...
0
推荐
1152
阅读
MYSQL 排序
-- 按金额降序，RANK排序SELECT T.SALES_OFFICE_CODE ,T.A_TNOR ,T.A_RANK ,@ROWNUM := @ROWNUM + 1 AS ROWNUM -- 行号初始化0，查询第一条语句的时候循环+1 ,@rank := (case when @PA = T.A_TNOR then @rank else @ROWNUM end) -- 判断当前数据和上一条数据是否一致，如果一致...