求sql排序
结构
TBA
id numA uptime
1 0 2004-12-11
2 1 2004-12-11
3 2 2004-12-11
4 0 2004-12-12
5 2 2004-12-13
6 2 2004-12-13
7 0 2004-12-14
8 0 2004-12-15
9 1 2004-12-16
10 1 2004-12-17
11 0 2004-12-17
结果
id numc uptime
5 2 2004-12-13
6 2 2004-12-13
10 1 2004-12-17
9 1 2004-12-16 ->这里两条numc=2 numc=1 为一组分别按uptime排序 直到没有
3 2 2004-12-11
2 1 2004-12-11
11 0 2004-12-17 ->没numc=2 numc=1没有时 numc=0按uptime排序
8 0 2004-12-15
7 0 2004-12-14
4 0 2004-12-12
1 0 2004-12-11
就是两条numc=2两条numc=1为一组显示没有再显示numc=0按uptime排序
谢谢各位了。这两天分花的真多啊,不过也学到不少 :)