建循序表 Tab_s:Id,Value
select * from Tab_s
1 L
2 Mi
3 Me
4 S
5 Fselect * from aTable a,Tab_s s
where a.Value=s.Value
and s.id>(select id from Tab_s where Value='Mi')
select * from Tab_s
1 L
2 Mi
3 Me
4 S
5 Fselect * from aTable a,Tab_s s
where a.Value=s.Value
and s.id>(select id from Tab_s where Value='Mi')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货