令人费解的'1' '-'排序,那位高人给解释一下
select a='-' into #t
union all select '1'
union all select '--'
union all select '-1'
union all select '1-'
union all select '11'
union all select '---'
union all select '--1'
union all select '-1-'
union all select '-11'
union all select '1--'
union all select '1-1'
union all select '11-'
union all select '111'
select * from #t order by a
drop table #t
结果:
a
----
-
--
---
1
-1
--1
-1-
1-
1--
11
-11
1-1
11-
111
(所影响的行数为 14 行)
为什么这个次序??