Sql的语句如下: case select * from 表名 order by substring(班级字段名,1,2), (case sumstring(班级字段名,3,16) when like '计算机' then sumstring(班级字段名,9,4) when like '财税' then sumstring(班级字段名,7,4) when ....)
Sql的语句如下: select * from 表名 order by substring(班级字段名,1,2), (case sumstring(班级字段名,3,16) when like '计算机' then sumstring(班级字段名,9,4) when like '财税' then sumstring(班级字段名,7,4))
case
select * from 表名
order by substring(班级字段名,1,2),
(case sumstring(班级字段名,3,16)
when like '计算机' then sumstring(班级字段名,9,4)
when like '财税' then sumstring(班级字段名,7,4)
when ....)
select * from 表名
order by substring(班级字段名,1,2),
(case sumstring(班级字段名,3,16)
when like '计算机' then sumstring(班级字段名,9,4)
when like '财税' then sumstring(班级字段名,7,4))
简单的说:我是要排按一、二、三、四、五的顺序排下去,而这个汉字的数字好像没办法简单的用order by?seamanwhh,看了你的回答一阵欣喜,可是紧接着还是比较迷惑,我看不懂你的SQL语句 :( ,而且那些班级的专业名也不是我所事先能知道的 :(