use studentDB
go
declare@StudentIdintselect@StudentId=StudnetId from Students where StudentName='张三'--查询学号在张三后面的学员select StudnetId,StudentName,Gender,Birthday from Students
where StudentId<
查询学号排在张三后面的学员信息方法一 使用变量方式实现use studentDBgodeclare @StudentId int select @StudentId=StudnetId from Students where StudentName='张三'--查询学号在张三后面的学员select StudnetId,StudentName,Gender,Birthday from Students where StudentId>@StudentId方法二 子查询s.