题目
有如下一张表G1212
希望通过SQL语句将连续的数据组合起来,结果如下:
注意审题
测试语句
CREATE TABLE G1212
(
X INT,
L VARCHAR(10)
) ;
INSERT INTO G1212 VALUES(1, 'A');
INSERT INTO G1212 VALUES(2, 'A');
INSERT INTO G1212 VALUES(3, 'A');
INSERT INTO G1212 VALUES(4, 'A');
INSERT INTO G1212 VALUES(5, 'B');
INSERT INTO G1212 VALUES(6, 'B');
INSERT INTO G1212 VALUES(7, 'B');
INSERT INTO G1212 VALUES(8, 'A');
INSERT INTO G1212 VALUES(9, 'A');