K

날짜 관련 쿼리 입니다. 한달을 요일별로 구함..

· 2007-10-24 (수) 18:04:13 · 4236

SELECT SUM(DECODE(A.A2, '1', A.A3, null)) 일요일,
       SUM(DECODE(A.A2, '2', A.A3, null)) 월요일,
       SUM(DECODE(A.A2, '3', A.A3, null)) 화요일,
       SUM(DECODE(A.A2, '4', A.A3, null)) 수요일,
       SUM(DECODE(A.A2, '5', A.A3, null)) 목요일,
       SUM(DECODE(A.A2, '6', A.A3, null)) 금요일,
       SUM(DECODE(A.A2, '7', A.A3, null)) 토요일
FROM
   ( SELECT rownum + 7 - to_number(TO_CHAR(TO_DATE('200312' || TO_CHAR(rownum),'YYYYMMDD'),'D')) as A1,
            TO_CHAR(TO_DATE('200312' || TO_CHAR(rownum), 'YYYYMMDD'), 'D') as A2,
            rownum as A3
     FROM user_objects
     WHERE rownum <= 31
       AND rownum > 0
       And TO_CHAR(LAST_DAY(TO_DATE('200312' || '01', 'YYYYMMDD')), 'DD')>= LTRIM(TO_CHAR(rownum, '00'))
   ) A
GROUP BY A.A1

 

 

일요일     월요일     화요일     수요일     목요일     금요일     토요일
------ ---------- ---------- ---------- ---------- ---------- ----------
                   1           2              3           4          5          6
     7             8           9            10          11         12         13
    14           15         16             17          18         19         20
    21           22         23             24          25         26         27
    28           29         30             31
 

 

www.en-core.com 에 이추형님의  글 입니다.

[이 게시물은 관리자님에 의해 2011-10-31 16:47:36 Oracle에서 이동 됨]
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
09-10-03 조회 3,153
08-02-03 조회 3,464
08-02-03 조회 3,403
08-01-30 조회 4,911
08-01-29 조회 2,789
08-01-27 조회 3,923
08-01-27 조회 2,857
08-01-27 조회 3,133
08-01-26 조회 8,682
08-01-26 조회 3,241
08-01-24 조회 5,291
08-01-23 조회 3,629
08-01-21 조회 3,673
08-01-21 조회 3,416
08-01-21 조회 3,429
08-01-18 조회 3,949
08-01-18 조회 4,592
08-01-18 조회 6,744
08-01-18 조회 4,030
08-01-17 조회 4,015
08-01-17 조회 3,836
08-01-16 조회 3,097
08-01-15 조회 3,484
08-01-14 조회 6,734
08-01-12 조회 4,331
08-01-12 조회 3,901
08-01-12 조회 4,610
08-01-12 조회 3,852
08-01-12 조회 4,143
08-01-11 조회 7,176
08-01-10 조회 3,909
08-01-08 조회 3,452
08-01-08 조회 3,928
08-01-06 조회 2,718
08-01-04 조회 1.1만
08-01-02 조회 5,801
07-12-28 조회 4,733
07-12-24 조회 3,152
07-12-21 조회 4,851
07-12-17 조회 3,629
07-12-14 조회 5,000
07-12-13 조회 6,431
07-12-10 조회 5,076
07-12-10 조회 3,955
07-12-10 조회 4,355
07-12-08 조회 3,711
07-12-07 조회 4,052
07-12-07 조회 3,175
07-12-06 조회 4,920
07-12-04 조회 3,496
07-12-04 조회 3,641
07-12-03 조회 3,403
07-12-03 조회 4,439
07-12-02 조회 3,268
07-11-30 조회 4,007
07-11-30 조회 5,236
07-11-30 조회 5,817
07-11-29 조회 3,686
07-11-27 조회 4,139
07-11-27 조회 5,917
07-11-27 조회 4,021
07-11-26 조회 3,132
07-11-23 조회 4,601
07-11-23 조회 4,331
07-11-22 조회 5,226
07-11-21 조회 3,453
07-11-21 조회 3,584
07-11-21 조회 1.2만
07-11-20 조회 4,961
07-11-16 조회 4,810
07-11-13 조회 4,478
07-11-12 조회 4,197
07-11-10 조회 5,583
07-11-08 조회 6,745
07-11-08 조회 5,070
07-11-07 조회 4,538
07-11-07 조회 4,989
07-11-06 조회 3,537
07-11-06 조회 3,907
07-11-05 조회 5,232
07-11-02 조회 4,116
07-11-01 조회 5,581
07-10-31 조회 3,274
07-10-30 조회 3,736
07-10-29 조회 3,725
07-10-26 조회 5,053
07-10-25 조회 5,130
07-10-25 조회 3,921
07-10-24 조회 3,917
07-10-24 조회 4,237
07-10-24 조회 4,094
07-10-24 조회 3,361
07-10-24 조회 3,476
07-10-23 조회 6,125
07-10-23 조회 5,509
07-10-22 조회 4,244
07-10-22 조회 3,625
07-10-22 조회 4,151
07-10-22 조회 3,744
07-10-19 조회 4,802