»

【SQL】ソートロジックについてのとりいそぎのメモ

SQL Server — enjoji.yasujiro @ 8:29 PM

with east as(
select nm =’東幹久’ ,tm = ‘あずまみきひさ’ union all
select nm =’東国原秀夫’,tm = ‘ひがしこくばるひでお’ union all
select nm =’東野幸治’ ,tm = ‘ひがしのこうじ’union all
select nm =’東儀秀樹’ ,tm = ‘とうぎひでき’union all
select nm =’東海林のり子’,tm = ‘しょうじのりこ’
)
select * from east order by tm

(続きを読む…)

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
(c) 2009 鎌倉橋日記 | powered by WordPress with Barecity