블로그
-
SQL 4주차 : Subquery, SUBSTRING, with, case
+익숙해지면 with구문을 이용해서 응용가능 자주 쓰이는 Subquery 유형 where, select, from 절에서 유용하게 사용됨. where절에서 쓰이는 Subquery select 활용하면 inner join~on~으로 묶어준 내용과 동일한 값으로 뽑을 수 있음.......
blog.naver.com · 2023.02.15
-
입체 슬라이드
INSTRUCTIONS: After you link on the site below and select an image and it appears, then: HOLD DOWN THE
blog.naver.com · 2021.10.19
-
오라클 DB LOCK 확인 및 제거
-- LOCK 걸린 개체 확인 SELECT OBJECT_ID , SESSION_ID -- SID , ORACLE_USERNAME , OS_USER_NAME FROM V$LOCKED_OBJECT C ON B.ID1 = C.OBJECT_ID WHERE B.TYPE = 'TM' ; -- LOCK을 발생시킨 사용자 정보 및 SQL 쿼리 확인 SELECT DISTINCT T1.SESSION_ID
blog.naver.com · 2021.06.02
-
m4a to wav 변환
On your MacOpen the Apple Music app. In the menu bar, choose Music > Preferences. Select the songs in your library that you want to convert. Choos.......
blog.naver.com · 2021.03.09
-
PostgreSQL data replication
CentOS Linux release 8.2.2004 (Core) (cat /etc/centos-release), AWS EC2 환경에서 테스트 DB: PostgreSQL 12.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit (select version)
blog.naver.com · 2021.02.17
-
2021년형 지바겐 585마력 Mercedes G63 AMG 4,0l with 585HP
2021년형 지바겐 585마력 Mercedes G63 AMG 4,0l with 585HP Mercedes G63 AMG 4,0l with 585HP, 2021 - ON STOCK! Gear reduction electrically switchable AMG Ride Control Suspension Differential locks 100% DYNAMIC SELECT
blog.naver.com · 2021.01.27
-
ABOUT US
Who can only be seen in high qualilty select shop. reasonable price, unique design also very elegant Preferred payment terms 30% Deposit - on order confirmation 70% Balance - 5days before shipment Shipping
blog.naver.com · 2020.06.26
-
table join
SELECT c.idx, c.word_t, c.class_t, c.frequency_t, c.synonyms_t, CASE WHEN a.word IS NOT NULL THEN 1 ELSE 0 END AS passed FROM vocalens_words_t c LEFT JOIN vocalens_pass a ON c.word_t = a.word WHERE c.idx>
blog.naver.com · 2019.09.08
-
정읍 고등 학생 초등수학과외 고창군 중등(중학생) 초등영어과외 국어 과학 개인 전문 쌤
In the future, the new society is based on what it has learned rather than on the knowledge it has gained.Choose college, there's a lot of activity going onIgo, we are evaluating creative problem solving skills to select
blog.naver.com · 2019.08.19
-
[Linux] rngd: 용어 관련
The -f or --foreground options can be used to tell rngd to avoid forking on startup. The -r or --rng-device options can be used to select an alternate source of input, besides the default
blog.naver.com · 2019.09.09
