排列问题

Question

表t
id       name     team
--------------------------------------
1 xx 0
2 xx2 1
3 xx3 1
4 xx4 1
5 vxx 1
6 vxx2 5
7 vxx3 5
8 vv 0
9 vv2 8
10 vv3 8
11 xx5 1
12 vxx4 5如果用一句 sql 获得以下排列结果？
id       name     team
------------------------------------------
1 xx 0
2 xx2 1
3 xx3 1
4 xx4 1
5 vxx 1
11 xx5 1
6 vxx2 5
7 vxx3 5
12 vxx4 5
8 vv 0
9 vv2 8
10 vv3 8先谢谢~~~~~~~~~~~~~~~~~~~~~

Answer 1

csdn处理了，看不清楚数据，lz重新贴下

Answer 2

表t
id       name     team
--------------------------------------
1        xx       0
2        xx       21
3        xx       31
4        xx       41
5        vxx      1
6        vxx      25
7        vxx      35
8        vv       0
9        vv       28
10       vv       38
11       xx       51
12       vxx      45如果用一句 sql 获得以下排列结果？
id       name     team
------------------------------------------
1        xx       0
2        xx       21
3        xx       31
4        xx       41
5        vxx      1
11       xx       51
6        vxx      25
7        vxx      35
12       vxx      45
8        vv       0
9        vv       28
10       vv       38再谢谢~~~~~~~~~~~~~~~~~~~~~

Answer 3

上面的求表错了！
表t
id       name     team
--------------------------------------
1        xx       0
2        xx2      1
3        xx3      1
4        xx4      1
5        vxx5     1
6        vxx      5
7        vxx      5
8        vv       0
9        vv2      8
10       vv3      8
11       xx5      1
12       vxx4     5如果用一句 sql 获得以下排列结果？
id       name     team
------------------------------------------
1        xx       0
5        vxx      1
6        vxx2     5
7        vxx3     5
12       vxx4     5
2        xx2      1
3        xx3      1
4        xx4      1
11       xx5      1
8        vv       0
9        vv2      8
10       vv3      8再次，再次谢谢~~~~~~~~~~~~~~~~~~~~~