摘要：
use pubsgoif exists(select name from sysobjects where name = 'emp')drop table empgo--复制表select emp_id,fname,lname into emp from dbo.employee--select * from emp--例如，求第3页，每页10条--即第21到30条记录select top 10 * from empwhere emp_id not in(select top 20 emp_id from emp order by emp_id)order by emp_id- 阅读全文
