블로그
-
oracle LISTAGG
= a.c1 AND b.c2 = a.c2 GROUP BY b.c1, b.c2 ) GROUP BY a.c1, a.c2; ====================== 1 1 20190701 (ORDER BY a.type desc) d_start from ( select 1 as c1, 1 as c2, 1 as type, '999.......
blog.naver.com · 2019.06.25
-
[하모니태민] 태민 WANT 해외 공동구매 / 모금 안내
GLOBAL GROUP ORDER AND FUNDRAISING organazed by SUPPORT UNION HARMONY TAEMIN dear. global SW! Before Group order and fundraising there is few important announcement.
blog.naver.com · 2019.02.05
-
[하모니태민] 태민 WANT 해외 공동구매 / 모금 안내
GLOBAL GROUP ORDER AND FUNDRAISING organazed by SUPPORT UNION HARMONY TAEMIN dear. global SW! Before Group order and fundraising there is few important announcement.
blog.naver.com · 2019.02.05
-
count, max, min, avg, sum, group by, having, order by, join
count: 결과 수를 구한다.(반환 타입: Long) MAX, MIN: 최대, 최소 값을 구한다. 문자, 숫자, 날짜 등에 사용 AVG: 평균값을 구한다. 숫자타입만 사용 가능 (반환 타입: Double) SUM: 합을 구한다. 숫자 타입만 사용할 수 있다. - 집합함수 사용시 참고
blog.naver.com · 2016.09.01
-
PARTITION 정리
TABLE_SCHEMA ,TABLE_NAME ,MAX(PARTITION_NAME) FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA ='KO_DB' GROUP BY TABLE_SCHEMA ,TABLE_NAME ORDER BY TABLE_SCHEMA ,TABLE_NAME ; 1) 파티션 ADD ALTER TABLE KO_NO5 ADD PARTITION
blog.naver.com · 2016.12.05
-
2016년 4월 28일 오후 5시 19분에 저장한 글입니다.
by article_title asc => select article_title,count(article_title) from article group by article_title => select article_title,count(article_title) from article group by article_title having length(article_title
blog.naver.com · 2016.04.28
-
오라클 쿼리 데이터 행을 열로 합치기
BY ROWNUM).Extract('//text()'), 2) filename from boardfile group by bno ) b on (a.no = b.bno) where 1=1 order by no asc ) tbl order by rownum desc; board 테이블에 글이 등록되어 있고 boardfile 테이블에 첨부파일이 다중으로 따로 저장되어
blog.naver.com · 2016.03.25
-
[MySQL] Group_Concat & Concat Function
tag_name)/(select count(*) from re_tag where user_num=54))*100,0) AS 'rank' from re_tag where user_num=54 group by tag_name order by rank desc limit 0, 5 ) tmp; 결과 예)
blog.naver.com · 2016.01.01
-
달력 소스 using pivot
달력 소스를 처음 봤을 때, connect by, group by가 쇼킹 했었는데, 11g의 pivot으로도 되네요. with T as ( -- 생성할 월 입력 select to_date ('201406','yyyymm') as target_date from dual ) select row_number() over (order by wek) as week, sun,mon
blog.naver.com · 2014.08.29
-
SQL 튜닝
= 'SALESMAN' group by job having sum(sal) >= 4000 order by sum(sal) desc; select job, sum(sal) from emp group by job having sum(sal) >= 4000 and job !
blog.naver.com · 2014.08.01
