sql 汉字简单排序

但是因为在数据库中存储顺序问题  出来的结果是 
 

SQL code?

1 2 3

用电二队 用电三队 用电一队

 取最大值

select * from runoob_tb2 a  join runoob_tbl b on a.runoob_id=b.runoob_id and a.Score=(select max(score) from runoob_tb2)

select distinct area_name from area_addr_info
order by charindex(substring(area_name,3,1),'一二三四')

select area_name from (select distinct area_name from area_addr_info_new) as v order by charindex(substring(area_name,3,1),'一二三四')