sql 显示1020数据

select * from Accounts_Permissions where PermissionID in (select top 20 PermissionID from Accounts_Permissions)
 and PermissionID not in (select top 10 PermissionID from Accounts_Permissions)
原文地址:https://www.cnblogs.com/xsmhero/p/1728282.html