但是因为在数据库中存储顺序问题 出来的结果是
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),'一二三四')
