问题是这样得,有一个表内容如下:
+-------------------+------------+---------+--------------+-----------+
| VRMachine0 | VRMachine1 | AppMemo | AppName | VRVersion |
+-------------------+------------+---------+--------------+-----------+
| 00:A0:D1:CF:00:0A | NULL | 1 | ELN | 1.0 |
| 00:A0:D1:CF:00:0A | NULL | 1 | ECS_Student | 1.0 |
| 00:A0:D1:CF:00:0A | NULL | 1 | ECS_Teacher | 1.0 |
| 00:A0:D1:CF:00:0A | NULL | 1 | Browser | 1.0 |
| 00:A0:D1:CF:00:0A | NULL | 1 | E_Mail | 1.0 |
| 00:A0:D1:CF:00:0A | NULL | 1 | Win2k | 1.0 |
| 00:A0:D1:CF:00:0A | NULL | 1 | Echo | 1.0 |
| 00:A0:D1:CF:22:0B | NULL | 1 | ELN | 1.1 |
| 00:A0:D1:CF:22:0B | NULL | 1 | ECS_Student | 1.1 |
| 00:A0:D1:CF:22:0B | NULL | 1 | ECS_Teacher | 1.1 |
| 00:A0:D1:CF:22:0B | NULL | 1 | Browser | 1.1 |
| 00:A0:D1:CF:22:0B | NULL | 1 | E_Mail | 1.1 |
| 00:A0:D1:CF:22:0B | NULL | 1 | Win2k | 1.1 |
| 00:A0:D1:CF:22:0B | NULL | 1 | Echo | 1.1 |
+-------------------+------------+---------+--------------+-----------+
如何查询可以得到下面得结果:(下面是两行记录)
00:A0:D1:CF:00:0A NULL 1 ELN 1.0 ECS_Student 1.0 ECS_Teacher 1.0 Browser 1.0 E_Mail 1.0 Win2k 1.0
00:A0:D1:CF:22:0B NULL 1 ELN 1.1 ECS_Student 1.1 ECS_Teacher 1.1 Browser 1.1 E_Mail 1.1 Win2k 1.1
+-------------------+------------+---------+--------------+-----------+
| VRMachine0 | VRMachine1 | AppMemo | AppName | VRVersion |
+-------------------+------------+---------+--------------+-----------+
| 00:A0:D1:CF:00:0A | NULL | 1 | ELN | 1.0 |
| 00:A0:D1:CF:00:0A | NULL | 1 | ECS_Student | 1.0 |
| 00:A0:D1:CF:00:0A | NULL | 1 | ECS_Teacher | 1.0 |
| 00:A0:D1:CF:00:0A | NULL | 1 | Browser | 1.0 |
| 00:A0:D1:CF:00:0A | NULL | 1 | E_Mail | 1.0 |
| 00:A0:D1:CF:00:0A | NULL | 1 | Win2k | 1.0 |
| 00:A0:D1:CF:00:0A | NULL | 1 | Echo | 1.0 |
| 00:A0:D1:CF:22:0B | NULL | 1 | ELN | 1.1 |
| 00:A0:D1:CF:22:0B | NULL | 1 | ECS_Student | 1.1 |
| 00:A0:D1:CF:22:0B | NULL | 1 | ECS_Teacher | 1.1 |
| 00:A0:D1:CF:22:0B | NULL | 1 | Browser | 1.1 |
| 00:A0:D1:CF:22:0B | NULL | 1 | E_Mail | 1.1 |
| 00:A0:D1:CF:22:0B | NULL | 1 | Win2k | 1.1 |
| 00:A0:D1:CF:22:0B | NULL | 1 | Echo | 1.1 |
+-------------------+------------+---------+--------------+-----------+
如何查询可以得到下面得结果:(下面是两行记录)
00:A0:D1:CF:00:0A NULL 1 ELN 1.0 ECS_Student 1.0 ECS_Teacher 1.0 Browser 1.0 E_Mail 1.0 Win2k 1.0
00:A0:D1:CF:22:0B NULL 1 ELN 1.1 ECS_Student 1.1 ECS_Teacher 1.1 Browser 1.1 E_Mail 1.1 Win2k 1.1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货