블로그
-
Books of the year 2015 (from Economist)
lifeThe best books this year are about North Korea, Detroit, Nagasaki and being a pilotDec 5th 2015 | From handled undercover operations from the communist revolution in 1917 until the end of the cold war.
blog.naver.com · 2015.12.07
-
Power of Pressure
People always get pressure from something to achieve their aim. Kennedy compromised with the Soviet Union by threatening them by saying he will shot missile to Cuban
blog.naver.com · 2015.09.22
-
오라클 정렬쿼리
SELECT * FROM ( SELECT * FROM (컬럼들, 1 seponum FROM 테이블명) WHERE ( 조건들 ) and DRTYPE like '%센터장%' union SELECT * FROM (컬럼들, 2 seponum FROM 테이블명) WHERE ( 조건들 ) and DRTYPE like '%은행장%' union SELECT * FROM (컬럼들
blog.naver.com · 2015.01.08
-
mssql 정렬쿼리
CONVERT(VARCHAR(20),WriteDate,111) as WriteDate2,B.FilePath ,A.LinkUrl,A.Contents,A.Relation, 1 fame FROM and Category = '5' and A.Name not like '%(재)%' and A.Name not like '%故%' and A.Name not like '%익명%' union
blog.naver.com · 2015.01.08
-
튜닝 2-2
group by job union all select null as job, sum(sal) from emp 튜닝후 SELECT job, SUM(sal) FROM EMP GROUP GROUP BY deptno UNION ALL SELECT NULL AS job, COUNT(*) FROM EMP; 튜닝후 SELECT deptno, COUNT(*) FROM EMP
blog.naver.com · 2014.08.06
-
7/28일-8/1일 글로벌금리 이벤트
(BBG/WSJ) The Eurozone banking union faces a ruling from the German constitutional court after case was (FT) Moody’s upgraded Portugal to Ba1 from Ba2 and assigned a stable outlook.
blog.naver.com · 2014.07.28
-
COMMA SUM
,PATINDEX('%,%', Vals) - 1) AS FLOAT) Val, RIGHT(Vals,LEN(Vals) - PATINDEX('%,%', Vals)) Remainder FROM @Table UNION ALL SELECT ID, CAST(LEFT(Remainder,CASE WHEN PATINDEX('%,%', Remainder) = 0 THEN LEN(Remainder
blog.naver.com · 2014.06.23
-
sum of comma separated values
START, stop) AS ( SELECT START = 1, stop = CHARINDEX(@delim COLLATE Slovenian_BIN2, @list + @delim) UNION SELECT START = stop + 1, stop = CHARINDEX(@delim COLLATE Slovenian_BIN2, @list + @delim, stop + 1) FROM
blog.naver.com · 2014.06.18
-
1/25 Economist 읽기
plans to reduce greenhouse gases, setting a binding goal for 2030 to reduce carbon emissions by 40% from It also wants energy from renewable sources, such as wind power, to account fo.......
blog.naver.com · 2014.02.04
-
3장. 사례 이해를 위한 기본사항
집합 연산자 하나의 SELECT 문의 결과 SET 다른 SELECT 문의 결과 SET을 합집합, 교집합, 차집합으로 새로운 결과 SET을 만들때 사용 1.1 UNION과 UNION 두 줄로 출력) SQL> select emp_id, salary, 0 comm from te.......
blog.naver.com · 2014.01.06
