Oracle 動態取周次
来源:互联网 发布:老虎证券 是人工智能 编辑:程序博客网 时间:2024/05/22 02:01
--計算當月天數及周次
SELECT rn, num_day,
CASE
WHEN MAX (rn)KEEP (DENSE_RANK LAST ORDER BY rn) OVER () = rn
THEN nextday
ELSE nextday - 1
END nextday
FROM (SELECT ROWNUM rn, num_day,LEAD (num_day, 1) OVER (ORDER BY num_day) nextday
FROM (SELECT 1 num_day
FROM DUAL
UNION
SELECT num_day
FROM (SELECT ROWNUM num_day,
TRIM
(TO_CHAR (TO_DATE ( '201002'|| TO_CHAR (ROWNUM, '00'),'yyyymmdd'),
'day','NLS_DATE_LANGUAGE = english')
) eng_day
FROM user_objects a
WHERE ROWNUM <=TO_CHAR (LAST_DAY (TO_DATE ('201002','yyyymm')),'dd')) cal
WHERE eng_day = 'monday'
UNION ALL
SELECT TO_NUMBER (TO_CHAR (LAST_DAY (TO_DATE ('201002','yyyymm')),'dd'))
FROM DUAL))
WHERE nextday IS NOT NULL
- Oracle 動態取周次
- Oracle???
- oracle
- oracle
- oracle
- oracle
- oracle...
- oracle
- oracle
- ORACLE
- Oracle
- ORACLE
- Oracle
- Oracle
- oracle
- oracle
- oracle
- ORACLE
- progma 语法
- 谈谈对Java中Unicode、编码的理解
- js实现前台动态添加文本框,后台获取文本框内容
- OnKickIdle使用详解
- 批处理插入数据
- Oracle 動態取周次
- linq to sql 学习(7)linq的分组汇总操作
- STDIN_FILENO与stdio的区别
- MFC的对话框中怎样加入背景音乐
- 看了很多人的面试经验,我也来一段:这段时间的几个面试
- 读取指定网页某区域内链接内容
- Tomcat配置优化
- string 遇上 “/0”
- linq to sql 学习(8)linq的多表查询实例