SQL Server 分页查询

时间:2021-09-07 16:38:01   收藏:0   阅读:28

 

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)

 

原文:https://www.cnblogs.com/TanOnly/p/15237430.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!