K

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

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

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건
+
제목 글쓴이 날짜 조회
07-10-19 조회 3,465
07-10-19 조회 3,225
07-10-19 조회 3,174
07-10-19 조회 2,877
07-10-19 조회 4,453
07-10-19 조회 5,819
07-10-19 조회 6,099
07-10-19 조회 3,484
07-10-19 조회 4,947
07-10-17 조회 4,598
07-10-17 조회 5,986
07-10-16 조회 4,610
07-10-15 조회 5,573
07-10-13 조회 5,247
07-10-09 조회 4,950
07-10-09 조회 4,285
07-10-09 조회 4,213
07-10-09 조회 4,771
07-10-09 조회 3,537
07-10-09 조회 3,318
07-10-09 조회 6,792
07-10-09 조회 3,942
07-10-09 조회 3,677
07-10-09 조회 3,996
07-10-09 조회 3,369
07-10-09 조회 4,407
07-10-08 조회 1.1만
07-10-05 조회 3,155
07-10-05 조회 4,080
07-10-03 조회 4,193
07-10-03 조회 3,398
07-10-03 조회 4,241
07-10-03 조회 5,262
07-10-03 조회 4,244
07-10-03 조회 3,644
07-10-03 조회 7,330
07-10-03 조회 4,912
07-10-03 조회 7,582
07-10-03 조회 3,679
07-10-03 조회 3,622
07-10-03 조회 3,629
07-10-03 조회 4,663
07-10-03 조회 4,618
07-10-03 조회 3,315
07-10-03 조회 5,176
07-10-03 조회 2,978
07-10-03 조회 2,650
07-10-03 조회 2,699
07-10-03 조회 2,908
07-10-03 조회 2,914
07-10-03 조회 4,732
07-10-02 조회 3,621
07-10-02 조회 3,153
07-10-02 조회 3,489
07-10-02 조회 5,794
07-10-02 조회 3,527
07-10-02 조회 4,152
07-10-02 조회 3,168
07-10-02 조회 4,832
07-10-02 조회 3,077
07-10-02 조회 8,910
07-10-02 조회 4,567
07-10-01 조회 2,532
07-10-01 조회 3,731
07-09-28 조회 4,756
07-09-28 조회 3,628
07-09-27 조회 3,526
07-09-27 조회 4,037
07-09-27 조회 5,079
07-09-27 조회 4,680
07-09-27 조회 3,817
07-09-27 조회 3,228
07-09-27 조회 3,281
07-09-27 조회 3,916
07-09-27 조회 3,252
07-09-15 조회 4,191
07-09-15 조회 2,907
07-09-13 조회 3,426
07-09-13 조회 2,947
07-09-13 조회 3,384
07-09-11 조회 3,619
07-09-09 조회 3,553
07-08-28 조회 3,495
07-08-28 조회 3,370
07-08-23 조회 4,674
07-08-22 조회 2,868
07-08-21 조회 4,653
07-08-21 조회 3,237
07-08-16 조회 6,508
07-08-07 조회 3,414
07-08-04 조회 3,541
07-08-04 조회 2,912
07-08-04 조회 3,322
07-08-04 조회 4,881
07-08-04 조회 2,724
07-08-04 조회 2,931
07-08-01 조회 5,567
07-08-01 조회 4,984
07-07-31 조회 4,445
07-07-31 조회 4,696