zZsSzss的博客

题目描述数据源是有a,b两列,然后根据b列的连续相同值,加一列序号先准备测试数据CREATE TABLE IF NOT EXISTS `test1`( yy int, nn int) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'; insert into table test1 values(2010,1);insert into table test1 values(2011,1);insert into table test1