"회의록 20210805"의 두 판 사이의 차이

2021년 8월 4일 (수) 21:43 판

select * from temp01Data

select class, count(*) from temp01Data
group by class order by class

select b.item as 편찬자, count(b.item) as 건수
from temp01Data a
cross apply fn_split(note,',') b
group by b.item
order by b.item

select * from temp01Links

select distinct relation, count(*) as 건수
from temp01Links
group by relation order by relation

select b.item as 편찬자, count(b.item) as 건수
from temp01Links a
cross apply fn_split(note,',') b
group by b.item
order by b.item

id	class	ㅣlen(id)	datalength(id)
Meine_Hochzeitsreise_durch_Korea_wahrend_des_Russisch-japanischen_Krieges	Record	73	146
환구단_축소예정문화재보호구역과조선일보_1982년9월10일_매각공고_사진_2007	Record	44	88
서울시_중구_정동_1-39번지_일대_문화유적_지표조사_보고서_2003	Record	38	76
환구단_조선지형집성상세_1921와_경성전도_1936_도면_2007	Multimedia	36	72
한국,_망명국가:_일제강점기_독립운동과_프랑스(1910-1945)	Event	36	72
미_외교관_부인이_만난_명성황후_영국_선원_앨런의_청일전쟁_비망록	Record	36	72
환구단_황궁우_내부_외진부분과_내부기둥과_천장구조_사진_2007	Record	35	70
우당_6형제의_독립운동_-_민국의_길,_자유의_길_온라인_전시	Record	34	68
환구단_그린파크_호텔주변_주거건축물과_정자건축물_사진_2007	Record	34	68
환구단_덕수궁내_정관헌과_창덕궁내_박물관부근모습_사진_2007	Record	34	68

@@ 246번째 줄: / 246번째 줄: @@
 **길이가 긴 id 확인됨(len(id)>40)
 {| class="wikitable sortable" style="background-color:white"
-! id !! class !! 문자열크기 !! 문자열바이트수
+! id !! class !! ㅣlen(id) !! datalength(id)
 |- style="background-color:#eaeaea"
 | Meine_Hochzeitsreise_durch_Korea_wahrend_des_Russisch-japanischen_Krieges || Record || 73 || 146