--测试数据
create table tbl_test(
orderNumber int,
textinput varchar(100),
refid varchar(50)
)
insert into tbl_test values
(1,'','123456789'),(2,'','123456789'),
(3,'111','123456789'),
(1,'','1234567890'),(2,'','1234567890'),
(3,'222','1234567890'),
(1,'','12345678900'),(2,'','12345678900'),
(3,'333','12345678900'),
(1,'','123456789000'),(2,'','123456789000'),
(3,'444','123456789000')
--现在的结果
+-------------+-----------+--------------+
| orderNumber | textinput | refid |
+-------------+-----------+--------------+
| 1 | | 123456789 |
| 2 | | 123456789 |
| 3 | 111 | 123456789 |
| 1 | | 1234567890 |
| 2 | | 1234567890 |
| 3 | 222 | 1234567890&
