the data in the table is sorted according to the sorted col. When querying, repeat the data in some fields of Filter [adjacent],
and save the value of the lowest sorted col (originally saved is time, the principle should be the same
such as:
create table tb (
eat int,
drink int,
col int;
)insert into tb(eat ,drink ,col) values(1,1,1);
insert into tb(eat ,drink ,col) values(1,1,2);
insert into tb(eat ,drink ,col) values(2,3,3);
insert into tb(eat ,drink ,col) values(2,3,4);
insert into tb(eat ,drink ,col) values(1,1,5);
insert into tb(eat ,drink ,col) values(1,1,6);
insert into tb(eat ,drink ,col) values(4,5,7);
insert into tb(eat ,drink ,col) values(5,6,8);
insert into tb(eat ,drink ,col) values(2,3,9); query Filter"s adjacent and identical ear,drink data, and keep the coll value
corresponding to the data jump. The result of the query should be as follows
1, br > 2, 3, br, 1, 5, br, 4, 5, 7, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 8, 5, 8, 5, 8, 2, 3, br, 9, br, call for help.
