블로그
-
임시테이블 사용시 Limit과 SubQuery 효과적으로 사용하기
ON rr.board_num = rb.board_num where rb.board_num in ( select board_num from ( select * from re_board ,0)) AS rating, rb.* from ( select * from re_board where user_num !
blog.naver.com · 2015.12.01
-
Convert to MultiScatter
Convert to MultiScatterSubmitted by pixamoon on Fri, 2015-12-11 13:265votesVersion: v0.30Date Updated to MultiScatter First it creates new distribution object and then MultiScatter distributes objects on
blog.naver.com · 2015.12.22
-
Using 3D Meshes as Textures in 3ds Max
Now create a simple (non chamfer) box somewhere in the scene and select all of the previously created Once this is done and you have the brickwall selected click on the source button located left on the
blog.naver.com · 2015.12.08
-
Redis 리눅스 설치
이거 보고 참고하자 http://codingsteps.com/install-redis-2-6-on-amazon-ec2-linux-ami-or-centos/ http://redis.io select the redis config file name [/etc/.......
blog.naver.com · 2015.11.20
-
[HYU-TESOL]Business TESOL Wednesday Class is also available
Business TESOL class dates from the people interested in the program but impossible to take classes on Business TESOL program applicants should select one of Wednesda.......
blog.naver.com · 2015.09.09
-
HIVE skew join
케이스에서는 hive 에서 skew join 이라는 최적화 기법을 제공하며 ( hive.optimize.skewjoin ) 해당 조인을 이용하여 처리시간을 조정할 수 있다. select count(*) from src a JOIN src b ON a.key=b.key SKEWED ON (a.key > 100 CLUSTER BY 20 PERCENT); 물론 skewed
blog.naver.com · 2015.06.19
-
mssql 정렬쿼리
SELECT A. A.LinkUrl,A.Contents,A.Relation, 1 fame FROM WEB_HONOR_TOWN AS A LEFT JOIN WEB_HONOR_TOWN_FILE AS B ON
blog.naver.com · 2015.01.08
-
[Oracle JDBC]SQL 쿼리문 작성 테스트[KOSTA 87기]2014년 10월 16일 월요일(16일차)
SELECT e.ENAME AS "이름", e.DEPTNO AS "부서번호", d.DNAME AS "부서이름" FROM emp e JOIN dept d ON e.DEPTNO = d.DEPTNO e JOIN dept d ON e.DEPTNO = d.DEPTNO WHERE d.LOC = 'DALLAS'; --OK -- 3.
blog.naver.com · 2014.10.16
-
Call for Applicants: KEI 2015 Winter/Spring Internship
KEI interns are on the cusp of current events, hearing the news before it is released, and organizing the very interviews that are shown on the evening news.
blog.naver.com · 2014.11.14
-
Theory New Styles Added to Summer Sale | 60% Off -
*Offer valid on select merchandise on theory.com and at theory retail locations.
blog.naver.com · 2014.07.04
