SQL Server 分页查询

 

1     select top (10) LogId,LoginId,SPName,ServerName,LoginTime,ExitTime from LoginLogs
2     where LogId not in (select top(10 *(3-1)) LogId from LoginLogs)

 

posted @ 2021-09-07 11:30  元数据  阅读(52)  评论(0)    收藏  举报