_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 襷蠏碁

3 #

覓語 sqler.pe.kr 覦蟆 覓語([http]). 襷襦 螳覲企 覓語螳 螳碁 觜訣 覦朱 碁 覓語. 覩語蟶 螳 螳襷 企瓦給. (襴襷 危危る 碁企 蟇企讌 讌.)

 蟆郁骸

num         a    b    c    d    e
----------- ---- ---- ---- ---- ----
5                              
4                              
3                             
2                             
1                            
0                           
NULL        1    3    5    0    2
--貎朱Μ 蟆郁骸 ろ碁 覲願 螻蠍語 佔(~~豌)襦 覲企 . 旧 覦蠑碁蟇 蠏谿朱 覃覈レ朱 覲旧伎 覲企 . 
with temp(num)
as
(
        select 6 numm
        union all
        select num - 1 from temp
        where num - 1 >= 0
),
val(a,b,c,d,e)
as
(
	select '1' a, '3' b, '5' c, '0' d, '2' e
)
select 
	case when b.num = 0 then null else b.num - 1 end num
,	case when b.num = 0 then a when b.num - 1 <= a.a then '' else '' end a
,	case when b.num = 0 then b when b.num - 1 <= a.b then '' else '' end b	
,	case when b.num = 0 then c when b.num - 1 <= a.c then '' else '' end c
,	case when b.num = 0 then d when b.num - 1 <= a.d then '' else '' end d
,	case when b.num = 0 then e when b.num - 1 <= a.e then '' else '' end e
from val a
	cross join temp b
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:53

螳 朱 蟲 豌 覺 讌朱 覦 螳襴襯 讌 . 覺 朱 覲旧蟒企 覯蟒 覿讌 . 襴 覿 ル瑚 企蟆 るジ 蟒覲企 蟆 朱 讌 . 蠏語 覓給牛 譴觜覃 願概 螻 訖企. 蠏碁り 襷る語襴 蠏語螻 讌 螳 蠍 谿襦螳 讌蠍 蟲 る 譴觜伎 蠏 リ鍵 襯 襷蟷 觸企 蟆企. (觜)