select * from 表A order by substring(name, 3, len(name)-2), name desc
select A.name, B.?? from 表A as A left join 表A as C on right(C.name,4) = right(A.name,4) and left(C.name,2) = '一' left join 表B as B on B.id = A.id order by C.id, A.id
select b.*, a.name from a, b where a.id=b.zhuanye order by substring(a.name, 3, len(a.name)-2), a.name desc
依赖于数据,请问有多少种级别?级别是有限的吗?select * from 表A order by substring(name, 3, len(name)-2), case left(name,1) when '一' then 1 when '二' then 2 when '三' then 3 else 100 end
select a.* ,b.* from A,B where a.id = b.id order by substring(a.name, 3, len(a.name)-2), case left(a.name,1) when '一' then 1 when '二' then 2 when '三' then 3 else 100 end
on right(C.name,4) = right(A.name,4) and left(C.name,2) = '一'
left join 表B as B on B.id = A.id
order by C.id, A.id
order by
substring(name, 3, len(name)-2),
case left(name,1) when '一' then 1 when '二' then 2 when '三' then 3 else 100 end
order by
substring(a.name, 3, len(a.name)-2),
case left(a.name,1) when '一' then 1 when '二' then 2 when '三' then 3 else 100 end