K

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

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

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,188건
+
제목 글쓴이 날짜 조회
08-06-19 조회 2,426
08-06-15 조회 3,174
08-06-15 조회 2,413
08-06-14 조회 2,752
08-06-14 조회 3,644
08-06-14 조회 3,336
08-06-12 조회 2,218
08-06-11 조회 2,251
08-06-11 조회 2,344
08-06-11 조회 7,377
08-06-11 조회 7,110
08-06-08 조회 3,290
08-06-07 조회 2,223
08-06-05 조회 2,345
08-06-05 조회 3,320
08-06-05 조회 2,686
08-06-05 조회 2,346
08-06-05 조회 2,372
08-06-04 조회 2,289
08-06-03 조회 2,283
08-06-03 조회 5,363
08-06-03 조회 3,595
08-06-02 조회 2,892
08-06-02 조회 4,032
08-06-01 조회 2,649
08-05-31 조회 2,349
08-05-31 조회 2,360
08-05-31 조회 2,439
08-05-30 조회 2,316
08-05-29 조회 2,460
08-05-29 조회 3,723
08-05-27 조회 5,568
08-05-26 조회 2,400
08-05-26 조회 5,313
08-05-25 조회 5,398
08-05-24 조회 2,466
08-05-23 조회 3,476
08-05-23 조회 2,876
08-05-23 조회 4,639
08-05-22 조회 2,637
08-05-21 조회 4,992
08-05-21 조회 4,762
08-05-21 조회 3,912
08-05-20 조회 4,511
08-05-20 조회 4,104
08-05-20 조회 3,329
08-05-20 조회 4,594
08-05-20 조회 3,942
08-05-20 조회 4,836
08-05-19 조회 2,378
08-05-16 조회 3,497
08-05-15 조회 2,559
08-05-15 조회 2,393
08-05-15 조회 2,385
08-05-14 조회 2,319
08-05-13 조회 2,776
08-05-13 조회 4,178
08-05-13 조회 4,605
08-05-09 조회 4,375
08-05-08 조회 3,128
08-05-08 조회 5,284
08-05-08 조회 2,638
08-05-07 조회 2,336
08-05-07 조회 2,487
08-05-07 조회 2,290
08-05-01 조회 2,615
08-05-01 조회 2,965
08-04-29 조회 3,808
08-04-28 조회 3,628
08-04-26 조회 2,642
08-04-26 조회 2,388
08-04-26 조회 3,656
08-04-25 조회 4,087
08-04-23 조회 4,522
08-04-22 조회 4,460
08-04-22 조회 3,616
08-04-22 조회 5,179
08-04-22 조회 4,555
08-04-22 조회 6,936
08-04-22 조회 4,004
08-04-21 조회 3,148
08-04-21 조회 3,199
08-04-21 조회 3,134
08-04-21 조회 2,966
08-04-21 조회 4,073
08-04-20 조회 3,241
08-04-20 조회 2,922
08-04-20 조회 3,456
08-04-19 조회 2,359
08-04-18 조회 3,064
08-04-18 조회 4,407
08-04-17 조회 3,623
08-04-17 조회 3,074
08-04-17 조회 3,292
08-04-17 조회 2,575
08-04-17 조회 2,976
08-04-17 조회 2,457
08-04-17 조회 3,009
08-04-17 조회 3,068
08-04-17 조회 2,273