SQL 用左补位方法进行排序(ORDER BY)
select right ('00000'+YmMonth,5) as YmMonth ,* from dbo.tblVisaYM order by right ('00000'+YmMonth,5) desc
左补位,如碰到数码长度不同是无法正确排序,用转换进行排序。如下:
order by CONVERT(decimal(12, 2), STR(HoleStart, 10, 3)) --desc
SQL 用左补位方法进行排序(ORDER BY)
select right ('00000'+YmMonth,5) as YmMonth ,* from dbo.tblVisaYM order by right ('00000'+YmMonth,5) desc
左补位,如碰到数码长度不同是无法正确排序,用转换进行排序。如下:
order by CONVERT(decimal(12, 2), STR(HoleStart, 10, 3)) --desc