Contents

1 KRX100
2


蠍一谿
谿
殊煙

るΜ
殊燕



覿一
覿
LG


手概譟
襦一狩


CJれ狩


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

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