블로그
-
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
blog.naver.com · 2019.09.08
-
[뉴욕] THE CASE FOR Loving: An Interracial Marriage
On June 12，1967， when the case of Loving v. Virginia began， (. . .) Then it was the Lovings’ lawyers’ turn to present their case.
blog.naver.com · 2017.12.26
-
HIVE Rollup 함수
when etl_ymd is null and equip_vendor is null then 'TOTAL' else etl_ymd end as etl_ymd , case when etl_ymd is not null and equip_vendor is null then 'SUB TOTAL' else equip_vendor end as equip_vendor , 3g_bts_cnt
blog.naver.com · 2017.02.24
-
# 69) 'For My Ladies' - DJ Deckstream
Melodee let's see, you got the house all, then you got the kids right gotta job plus you cook the meals always look good, cheering out in daylight live healthy so you googling the websites gain weight, then
blog.naver.com · 2016.10.10
-
REPLACE(LTRIM(RTRIM(SYS_CONNECT_BY_PATH_2
( case when level = 2 then goods_clssf_nm END, '^'))), '^', '') AS NAME2 ,REPLACE(LTRIM(RTRIM(SYS_CONNECT_BY_PATH ( case when level = 4 then goods_clssf_nm END, '^'))), '^', '') AS NAME4 FROM MD_GOODS_CLSSF_BAS START
blog.naver.com · 2015.01.06
-
REPLACE(LTRIM(RTRIM(SYS_CONNECT_BY_PATH
WHEN LEVEL=1 THEN BRAND_KOR_NM ELSE NULL END, '^'))), '^', '') NAME1 , REPLACE(LTRIM(RTRIM(SYS_CONNECT_BY_PATH ( CASE WHEN LEVEL=2 THEN BRAND_KOR_NM ELSE NULL END, '^'))), '^', '') NAME2 , REGI_SPR_CD FROM MD_BRAND_BAS
blog.naver.com · 2015.01.06
-
COMMA SUM
WHEN PATINDEX('%,%', Remainder) = 0 THEN LEN(Remainder) ELSE PATINDEX('%,%', Remainder) - 1 END) AS FLOAT) Val, RIGHT(Remainder,CASE WHEN PATINDEX('%,%', Remainder) = 0 THEN 0 ELSE LEN(Remainder) - PATINDEX
blog.naver.com · 2014.06.23
-
sum of comma separated values
stop > 0 ) SELECT row_number() over (order by Start) as ID, LTRIM(RTRIM(SUBSTRING(@list, START, CASE WHEN stop > 0 THEN stop - START ELSE 0 END))) AS VALUE FROM csvtbl WHERE stop > 0 GO Declare @
blog.naver.com · 2014.06.18
-
Case 1 흉통 chest pain
Case 1 48세 남자. Mr. Sam. C/C chest pain Hello. Mr. Sam. I am Dr. Seong. When did it start?
blog.naver.com · 2014.03.03
-
Mysql case문
mysql case문 2가지 방법 1번째 방법) SELECT 컬럼,컬럼, ( CASE 비교컬럼 WHEN 비교값 THEN '처리문' WHEN 비교값 THEN '처리문' ELSE '처리문 ' END ) AS TEST FROM 테이블 WHERE 조건 1번째 예시) SELECT gender, ( CASE gender WHEN 'f' THEN '여성' WHEN 'm' THEN
blog.naver.com · 2013.10.18
