查询部分属性
select top 5 v.EmpId, v.DeptName,v.EmpName,v.IDCard,v.EnterDutyDate,v.ContractLength,v.BDate,v.Edate,v.WorkState,v.Memo
from v_tbv v
where v.CompanyId= 448 and v.WorkState = '在职'
and v.EmpId not in(select top ((n-1)*5) v.EmpId from v_tbv v where v.CompanyId= 448 and v.WorkState = '在职' )
查询*
select top 5 *
from v_tbv v
where v.CompanyId= 448 and v.WorkState = '在职'
and v.EmpId not in(select top ((n-1)*5) v.EmpId from v_tbv v where v.CompanyId= 448 and v.WorkState = '在职' )
这两条sql除了得到的结果集有区别，查询本身是一样的。从第二页（n=2）开始结果都是一样的，但是为什么第一页（n=1）的结果不一样呢？