_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 譯殊れ豢
Data Analysis(R)
Data Analysis(Python)
Statistics
Data Warehouse
Database System
SQL Server
Trino
Hive
Hadoop
Regular Expressions
Tools
Money
Working Smart
Blog
Booklog
Philosophy
Link
Miscellaneous
__ edit




Contents

1 KRX100
2 譯


蠍一谿
谿
殊煙

るΜ
殊燕
豌
誤
蟲
覿一
覿
LG

れ
手概譟
襦一狩
螳
れ
CJれ狩


[edit]

1 KRX100 #

declare @rand int;
declare @i int;
declare @ex int;

set @i = 1;
set @rand = rand() * 10;
set @ex = 3; --豢豢譬覈

declare @tbl table
(
	譬覈 varchar(50)
);

while(@i <= 1000)
begin
	with 譯殊
	AS
	(
		select '' 譬覈覈 union all
		select '危誤' 譬覈覈 union all
		select '襴殊一' 譬覈覈 union all
		select '蟲伎' 譬覈覈 union all
		select '蠍一谿' 譬覈覈 union all
		select '企' 譬覈覈 union all
		select '讌伎' 譬覈覈 union all
		select '殊燕' 譬覈覈 union all
		select '殊焔殊' 譬覈覈 union all
		select '' 譬覈覈 union all
		select 'CJ' 譬覈覈 union all
		select '蟲螳' 譬覈覈 union all
		select '朱讌' 譬覈覈 union all
		select '' 譬覈覈 union all
		select '伎' 譬覈覈 union all
		select 'るΜ' 譬覈覈 union all
		select 'KCC' 譬覈覈 union all
		select 'LIG企慨' 譬覈覈 union all
		select '讀蟠' 譬覈覈 union all
		select '螻' 譬覈覈 union all
		select '讀蟠' 譬覈覈 union all
		select 'LG' 譬覈覈 union all
		select 'SK' 譬覈覈 union all
		select '豌' 譬覈覈 union all
		select '瑚' 譬覈覈 union all
		select '' 譬覈覈 union all
		select '誤' 譬覈覈 union all
		select '襦一螻' 譬覈覈 union all
		select '蟲' 譬覈覈 union all
		select '覿一' 譬覈覈 union all
		select '谿' 譬覈覈 union all
		select 'POSCO' 譬覈覈 union all
		select '覿' 譬覈覈 union all
		select '伎' 譬覈覈 union all
		select '殊煙' 譬覈覈 union all
		select '磯Μ讀蟠' 譬覈覈 union all
		select 'LS' 譬覈覈 union all
		select 'GS蟇伎' 譬覈覈 union all
		select '一蟠' 譬覈覈 union all
		select '覩語渚' 譬覈覈 union all
		select '殊煙蠍' 譬覈覈 union all
		select '譴螻旧' 譬覈覈 union all
		select '' 譬覈覈 union all
		select 'OCI' 譬覈覈 union all
		select '螻れ' 譬覈覈 union all
		select '殊煙螻旧' 譬覈覈 union all
		select '覩誤譟一' 譬覈覈 union all
		select 'SOil' 譬覈覈 union all
		select '碁' 譬覈覈 union all
		select '' 譬覈覈 union all
		select '覈觜' 譬覈覈 union all
		select '殊燕' 譬覈覈 union all
		select '一' 譬覈覈 union all
		select 'れ' 譬覈覈 union all
		select '蟲' 譬覈覈 union all
		select '殊煙蟠' 譬覈覈 union all
		select 'SK貊' 譬覈覈 union all
		select '手概譟' 譬覈覈 union all
		select '' 譬覈覈 union all
		select '螻' 譬覈覈 union all
		select '讌貊' 譬覈覈 union all
		select '讌蠍一' 譬覈覈 union all
		select '襦一狩' 譬覈覈 union all
		select '蠍一' 譬覈覈 union all
		select '企Д' 譬覈覈 union all
		select '手鍵' 譬覈覈 union all
		select 'KT' 譬覈覈 union all
		select 'XKTF' 譬覈覈 union all
		select 'LG貊' 譬覈覈 union all
		select 'KT&G' 譬覈覈 union all
		select '一螻旧' 譬覈覈 union all
		select 'LGろ' 譬覈覈 union all
		select '螳' 譬覈覈 union all
		select 'NHN' 譬覈覈 union all
		select 'れ' 譬覈覈 union all
		select 'CJれ狩' 譬覈覈 union all
		select '蟲螳り概' 譬覈覈 union all
		select '' 譬覈覈 union all
		select 'CJ誤磯' 譬覈覈 union all
		select '' 譬覈覈 union all
		select 'ろ' 譬覈覈 union all
		select '一＾伎' 譬覈覈 union all
		select '一誤殊' 譬覈覈 union all
		select '碁豌' 譬覈覈 union all
		select '郁唄' 譬覈覈 union all
		select '一誤磯伎' 譬覈覈 union all
		select 'LG蟇願' 譬覈覈 union all
		select 'LG' 譬覈覈 union all
		select '磯Μ蠍' 譬覈覈 union all
		select '讌譯' 譬覈覈 union all
		select 'LG' 譬覈覈 union all
		select '覦燕' 譬覈覈 union all
		select '蟲蠍旧譯' 譬覈覈 union all
		select '覃螳ろ磯' 譬覈覈 union all
		select 'GS' 譬覈覈 union all
		select '蠍旧譯' 譬覈覈 union all
		select '覈殊' 譬覈覈 union all
		select 'LG' 譬覈覈 union all
		select 'SK讌' 譬覈覈 union all
		select 'KB蠍' 譬覈覈 
	)
	insert @tbl
	select top (3) 譬覈覈
	from 譯殊
	order by newid();

	set @i = @i + 1;
end

select top(@ex)
	譬覈
,	count(*) cnt
from @tbl a
group by 譬覈
order by 2 desc

[edit]

2 譯 #

--5%
declare @rand int;
declare @i int;
declare @ex int;

set @i = 1;
set @rand = rand() * 10;
set @ex = 3; --豢豢譬覈

declare @tbl table
(
	譬覈 varchar(50)
);

while(@i <= 1000)
begin
	with 譯殊
	AS
	(
		select '' 譬覈覈 union all
		select '旧' 譬覈覈 union all
		select '' 譬覈覈 union all
		select '襴殊一' 譬覈覈 union all
		select '蟲伎' 譬覈覈 union all
		select '蠍一谿' 譬覈覈 union all
		select '企' 譬覈覈 union all
		select '' 譬覈覈 union all
		select '讌伎' 譬覈覈 union all
		select '蟇伎' 譬覈覈 union all
		select '殊燕' 譬覈覈 union all
		select '殊焔殊' 譬覈覈 union all
		select '' 譬覈覈 union all
		select '蟲螳' 譬覈覈 union all
		select '朱讌' 譬覈覈 union all
		select '伎' 譬覈覈 union all
		select 'SKろ語' 譬覈覈 union all
		select 'KCC' 譬覈覈 union all
		select '蟯一' 譬覈覈 union all
		select '讀蟠' 譬覈覈 union all
		select '螻' 譬覈覈 union all
		select 'LG' 譬覈覈 union all
		select 'SK' 譬覈覈 union all
		select '貊襴襴' 譬覈覈 union all
		select '殊煙覦' 譬覈覈 union all
		select '豌' 譬覈覈 union all
		select '瑚' 譬覈覈 union all
		select '' 譬覈覈 union all
		select '' 譬覈覈 union all
		select '誤' 譬覈覈 union all
		select '襦一螻' 譬覈覈 union all
		select '襦一' 譬覈覈 union all
		select '谿' 譬覈覈 union all
		select 'POSCO' 譬覈覈 union all
		select '覿' 譬覈覈 union all
		select '殊煙' 譬覈覈 union all
		select '磯Μ讀蟠' 譬覈覈 union all
		select 'LS' 譬覈覈 union all
		select 'GS蟇伎' 譬覈覈 union all
		select '殊SDI' 譬覈覈 union all
		select '一蟠' 譬覈覈 union all
		select '殊煙蠍' 譬覈覈 union all
		select '譴螻旧' 譬覈覈 union all
		select 'OCI' 譬覈覈 union all
		select 'LS一' 譬覈覈 union all
		select '螻れ' 譬覈覈 union all
		select '殊煙螻旧' 譬覈覈 union all
		select '覩誤譟一' 譬覈覈 union all
		select 'SOil' 譬覈覈 union all
		select '碁' 譬覈覈 union all
		select '' 譬覈覈 union all
		select '覈觜' 譬覈覈 union all
		select '殊燕' 譬覈覈 union all
		select '一' 譬覈覈 union all
		select 'れ' 譬覈覈 union all
		select '蟲' 譬覈覈 union all
		select 'LG一伎修' 譬覈覈 union all
		select '殊煙蟠' 譬覈覈 union all
		select 'SK貊' 譬覈覈 union all
		select '讌貊' 譬覈覈 union all
		select '襦一狩' 譬覈覈 union all
		select '蠍一' 譬覈覈 union all
		select '危' 譬覈覈 union all
		select '殊煙讌企' 譬覈覈 union all
		select 'STXれ' 譬覈覈 union all
		select '殊煙拘' 譬覈覈 union all
		select 'KT' 譬覈覈 union all
		select 'XKTF' 譬覈覈 union all
		select 'LG貊' 譬覈覈 union all
		select 'KT&G' 譬覈覈 union all
		select '一螻旧' 譬覈覈 union all
		select 'LGろ' 譬覈覈 union all
		select '螳' 譬覈覈 union all
		select 'NHN' 譬覈覈 union all
		select '蟲螳り概' 譬覈覈 union all
		select '' 譬覈覈 union all
		select '覩碁讀蟠' 譬覈覈 union all
		select '一＾伎' 譬覈覈 union all
		select '一誤殊' 譬覈覈 union all
		select '郁唄' 譬覈覈 union all
		select '一誤磯伎' 譬覈覈 union all
		select 'KPS' 譬覈覈 union all
		select 'LG蟇願' 譬覈覈 union all
		select 'LG' 譬覈覈 union all
		select '磯Μ蠍' 譬覈覈 union all
		select '讌譯' 譬覈覈 union all
		select 'LG' 譬覈覈 union all
		select 'STX譟一伎' 譬覈覈 union all
		select '覦燕' 譬覈覈 union all
		select '蟲蠍旧譯' 譬覈覈 union all
		select 'GS' 譬覈覈 union all
		select '蠍襦觜' 譬覈覈 union all
		select '蠍旧譯' 譬覈覈 union all
		select '襷レ深襴誤' 譬覈覈 union all
		select '覈殊' 譬覈覈 union all
		select 'SK讌' 譬覈覈 union all
		select '讌譴螻旧' 譬覈覈 union all
		select 'CJ殊' 譬覈覈 union all
		select '危碁Д譯' 譬覈覈 union all
		select 'KB蠍' 譬覈覈 
	)
	insert @tbl
	select top (3) 譬覈覈
	from 譯殊
	order by newid();

	set @i = @i + 1;
end

select top(@ex)
	譬覈
,	count(*) cnt
from @tbl a
group by 譬覈
order by 2 desc
鏤
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

豺覓牛 一旧朱 覲碁 襦 螳螻 矩. れ旧 螳 伎螻 れ旧 覿′覃伎 襯 蠍磯る 覓企ゴ牛 一旧 螻 矩. 旧 螳企 殊朱 讌蠏語 豈覃伎 リ鍵襦 譯朱 覦蠍磯ゼ 蠍磯るΥ 蠍磯ゼ 覦.蠏碁Μ 襷 襷 (讌)