- 博客(7)
- 资源 (2)
- 收藏
- 关注
原创 枚举上月的日期
有学生提这个需求,这个太好实现了,肯定是没好好听课SELECT last_m + (LEVEL - 1) AS d FROM (SELECT add_months(trunc(SYSDATE, 'mm'), -1) last_m, trunc(SYSDATE, 'mm') m FROM dual)CONNECT BY LEVEL <= m
2014-10-15 17:26:53 888
原创 mysql之wm_concat
SET @enames=''; SET @last_deptno=-1; SELECT deptno, MAX(enames) AS enames FROM (SELECT deptno, IF(@last_deptno = deptno, @rn := @rn + 1, @rn := 1) AS rn, IF(@last_
2014-10-11 20:08:14 7722
原创 mysql之累加
SET @add_sal=0; SELECT deptno, empno, ename, sal, @add_sal := @add_sal + sal AS add_sal FROM emp ORDER BY empno;+--------+-------+--------+------+---------+| deptno | empno | ename | sal | a
2014-10-11 20:03:15 8207
原创 mysql 之 rank() over()
SET @rn=0;SET @dense_rank=0;SET @last_deptno=-1;SET @last_sal=-1;SET @ADD = 0;SELECT deptno, empno, ename, sal, IF(@last_deptno = deptno, @rn := @rn + 1, @rn := 1) AS
2014-10-11 17:51:26 12184 3
原创 mysq 之 dense_rank() over()
SET @rn=0;SET @last_deptno=-1;SET @last_sal=-1;SELECT deptno, empno, ename, sal, IF(@last_deptno = deptno, @rn := @rn + IF(@last_sal = sal,0,1), @rn := 1) AS dense_rank,
2014-10-11 17:42:03 2542
Microsoft Jet 参考
2013-07-14
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人