假设 :select pub_id ,fname,lname from employee order by pub_id
pub_id fname lname1389 Pedro Afonso
1389 Aria Cruz
1389 Maria Larsson
1389 Yoshi Latimer
1389 Sven Ottlieb
1389 Miguel Paolino
1389 Paula Parente
1389 Diego Roel
1389 Carine Schmitt
1389 Margaret Smith1622 Rita Muller
1756 Maria Pontes
9901 Janine Labrune9952 Ann Devon
9952 Francisco Chang
9952 Philip Cramer9999 Carlos Hernadez
9999 Pirkko Koskitalo
9999 Karla Jablonski
9999 Helvetius Nagy
9999 Annette Roulet
9999 Manuel Pereira
9999 Patricia McKenna合并之后是:
pub_id fname lname Pedro Afonso
Aria Cruz
Maria Larsson
1389 Yoshi Latimer
Sven Ottlieb
Miguel Paolino
Paula Parente
Diego Roel
Carine Schmitt
Margaret Smith1622 Rita Muller
1756 Maria Pontes
9901 Janine Labrune Ann Devon
9952 Francisco Chang
Philip Cramer Carlos Hernadez
Pirkko Koskitalo
Karla Jablonski
Helvetius Nagy
9999 Annette Roulet
Manuel Pereira
Patricia McKenna在DataGrid中是这样显示的,那该怎么做呢? 急啊!!!
pub_id fname lname1389 Pedro Afonso
1389 Aria Cruz
1389 Maria Larsson
1389 Yoshi Latimer
1389 Sven Ottlieb
1389 Miguel Paolino
1389 Paula Parente
1389 Diego Roel
1389 Carine Schmitt
1389 Margaret Smith1622 Rita Muller
1756 Maria Pontes
9901 Janine Labrune9952 Ann Devon
9952 Francisco Chang
9952 Philip Cramer9999 Carlos Hernadez
9999 Pirkko Koskitalo
9999 Karla Jablonski
9999 Helvetius Nagy
9999 Annette Roulet
9999 Manuel Pereira
9999 Patricia McKenna合并之后是:
pub_id fname lname Pedro Afonso
Aria Cruz
Maria Larsson
1389 Yoshi Latimer
Sven Ottlieb
Miguel Paolino
Paula Parente
Diego Roel
Carine Schmitt
Margaret Smith1622 Rita Muller
1756 Maria Pontes
9901 Janine Labrune Ann Devon
9952 Francisco Chang
Philip Cramer Carlos Hernadez
Pirkko Koskitalo
Karla Jablonski
Helvetius Nagy
9999 Annette Roulet
Manuel Pereira
Patricia McKenna在DataGrid中是这样显示的,那该怎么做呢? 急啊!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货