/* ID NUM 1 800 2 855 3 866 4 800 5 844 如何查NUM字段指定数据后一行记录?如NUM字段中800后一条记录 */ create table tb(ID int, NUM int) insert into tb values(1 , 800 ) insert into tb values(2 , 855 ) insert into tb values(3 , 866 ) insert into tb values(4 , 800 ) insert into tb values(5 , 844 ) go
--如果ID连续 select m.* from tb m , tb n where m.id = n.id + 1 and n.num = 800 /*
ID NUM ----------- ----------- 2 855 5 ......
阅读全文