子查询的使用
use StuManageDB
go
--使用变量方式实现
declare @StuId int
Select @StuId=StudentId from Students where StudentName='张永利'
Select StudentName,Gender,Age from Students
where StudentId>@StuId
--使用子查询实现
Select StudentName,Gender,Age from Students
where StudentId&g