sql 显示10-20数据

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)
posted @ 2010-05-05 17:45  小さいです哥  阅读(305)  评论(3)    收藏  举报