求SQL语句,高手赐教，想的我脑袋都大了！！！！

Question

id,sdate, fjrxm,sjrxm,sjrdh,name,pp,kno,nno,  pakagenum,nums,volume,weight,price,bdcharge,payme0   07-12   A     B     123                       2     20     16    3      2.6     45      65
0   07-12   A     B     123                        2    30     22    4      4.3     50      85
1   07-12                    AAA  G  G6  M116-01        12           1           
2   07-12                    BBB  G  G6  M116-02         8           2                 
3   07-12                    CCC  G  G6  M166-01        16           2                
4   07-12                    DDD  G  G6  M166-02        14           2           
------------------------------------------------------------------------------------------------
id,sdate, fjrxm,sjrxm,sjrdh,name,pp,kno,nno, pakagenum,nums,volume,weight,price,bdcharge,payme0   07-12   A     B     123                        2   20    16      3    3       45       65
1   07-12                    AAA  F  F6  M116-01                     1         
2   07-12                    BBB  E  E6  M116-02       30            2                
0   07-12   A     B     123                        2         22      4            50       85
3   07-12                    CCC  V  V6  M166-01                     2               
4   07-12                    DDD  W  W6  M166-02                     2          

Answer 1

id,sdate, fjrxm,sjrxm,sjrdh,name,pp,kno,nno,  pakagenum,nums,volume,weight,price,bdcharge,payme
 
0   07-12   A     B     123                       2     20     16    3      2.6     45      65
0   07-12   A     B     123                        2    30     22    4      4.3     50      85
1   07-12                    AAA  G  G6  M116-01        12           1           
2   07-12                    BBB  G  G6  M116-02         8           2                 
3   07-12                    CCC  G  G6  M166-01        16           2                
4   07-12                    DDD  G  G6  M166-02        14           2     原始图的数据      
------------------------------------------------------------------------------------------------
我想要把试图的变成下面的显示方式：
id,sdate, fjrxm,sjrxm,sjrdh,name,pp,kno,nno, pakagenum,nums,volume,weight,price,bdcharge,payme
 
0   07-12   A     B     123                        2   20    16      3    3       45       65
1   07-12                    AAA  F  F6  M116-01                     1         
2   07-12                    BBB  E  E6  M116-02       30            2                
0   07-12   A     B     123                        2         22      4            50       85
3   07-12                    CCC  V  V6  M166-01                     2               
4   07-12                    DDD  W  W6  M166-02                     2          

Answer 2

id,sdate, fjrxm,sjrxm,sjrdh,name,pp,kno,nno,  pakagenum,nums,volume,weight,price,bdcharge,payme
 
0   07-12   A     B     123                       2     20     16    3      2.6     45      65
0   07-12   A     B     123                        2    30     22    4      4.3     50      85
1   07-12                    AAA  G  G6  M116-01        12           1           
2   07-12                    BBB  G  G6  M116-02         8           2                 
3   07-12                    CCC  G  G6  M166-01        16           2                
4   07-12                    DDD  G  G6  M166-02        14           2   原始图数据        
------------------------------------------------------------------------------------------------
想要变成下面的显示方式：
id,sdate, fjrxm,sjrxm,sjrdh,name,pp,kno,nno, pakagenum,nums,volume,weight,price,bdcharge,payme
 
0   07-12   A     B     123                        2   20    16      3    3       45       65
1   07-12                    AAA  F  F6  M116-01                     1         
2   07-12                    BBB  E  E6  M116-02       30            2                
0   07-12   A     B     123                        2         22      4            50       85
3   07-12                    CCC  V  V6  M166-01                     2               
4   07-12                    DDD  W  W6  M166-02                     2          

Answer 3

结果表里面，F、F6，E、E6，V、V6，W、W6哪来的？
还有一些数据有变化，不知道哪来的。最好说说想要什么功能吧……

Answer 4

不好意思，写错了,数据时我瞎编的，上面的是我视图表查出来的结果，我想把上面的结果集变成下面格式显示。
id,sdate, fjrxm,sjrxm,sjrdh,name,pp,kno,nno,  pakagenum,nums,volume,weight,price,bdcharge,payme
  
0   07-12   A     B     123                       2     20     16    3      2.6     45      65
0   07-12   A     B     123                        2    30     22    4      4.3     50      85
1   07-12                    AAA  F  F6  M116-01        12           1           
2   07-12                    BBB  E  F6  M116-02         8           2                 
3   07-12                    CCC  V  V6  M166-01        16           2                
4   07-12                    DDD  W  W6  M166-02        14           2   
 
原始图数据        
------------------------------------------------------------------------------------------------
想要变成下面的显示方式：
id,sdate, fjrxm,sjrxm,sjrdh,name,pp,kno,nno, pakagenum,nums,volume,weight,price,bdcharge,payme
  
0   07-12   A     B     123                        2   20    16      3    3       45       65
1   07-12                    AAA  F  F6  M116-01                     1         
2   07-12                    BBB  E  E6  M116-02       30            2                
0   07-12   A     B     123                        2         22      4            50       85
3   07-12                    CCC  V  V6  M166-01                     2               
4   07-12                    DDD  W  W6  M166-02                     2           

Answer 5

不好意思，写错了,数据时我瞎编的，上面的是我视图表查出来的结果，我想把上面的结果集变成下面格式显示。
id,sdate, fjrxm,sjrxm,sjrdh,name,pp,kno,nno,  pakagenum,nums,volume,weight,price,bdcharge,payme
   
0   07-12   A     B     123                       2     20     16    3      2.6     45      65
0   07-12   A     B     123                        2    30     22    4      4.3     50      85
1   07-12                    AAA  F  F6  M116-01        12           1           
2   07-12                    BBB  E  F6  M116-02         8           2                 
3   07-12                    CCC  V  V6  M166-01        16           2                
4   07-12                    DDD  W  W6  M166-02        14           2   
  
原始图数据        
------------------------------------------------------------------------------------------------
想要变成下面的显示方式：
id,sdate, fjrxm,sjrxm,sjrdh,name,pp,kno,nno, pakagenum,nums,volume,weight,price,bdcharge,payme
   
0   07-12   A     B     123                        2   20    16      3    3       45       65
1   07-12                    AAA  F  F6  M116-01       12            1         
2   07-12                    BBB  E  E6  M116-02       8             2                
0   07-12   A     B     123                        2   30     22     4            50       85
3   07-12                    CCC  V  V6  M166-01       16            2               
4   07-12                    DDD  W  W6  M166-02       14            2           

Answer 6

et024说的没错，楼主你根本就没有描述或者描述的相当不清楚。
除了et024说的，还有比如为什么2.6变成了3了？我猜是四舍五入，可是为什么4.3在结果集消失啦？我猜是楼主漏写了。
楼主有没有发现我们都在猜？
所以，从另外一方面来说，你描述的相等不清楚。
重新描述下吧。

Answer 7

你的表设计有问题啊，我理解你的意思了，你是想把李明和张三的货物分开来显示。但是他们的货物也需要一个字段来区分啊。你懂我的意思么，建议你在表里面加个字段，A代表李明的，B代表张三的，最后order一下，立马就能分开。

Answer 8

在所有信息里加上“Re”字段，所以李明的货物包括李明自己为A，剩下的为B。最后
order by re, price DESC试一下。

Answer 9

lz,把你的视图表sql语句修改下，把1，2，3，4的项目或联系人显示出来做下排序就是你想要的。
或者你做个标识012，034分别是一起的数据。然后再做排序也可以的。