摘要： SQL语句：Select * From (Select (ROW_NUMBER() OVER(ORDER BY ID asc)) AS rownum,* From [TABLENAME]) tWhere rownum BETWEEN 1 AND 20说明：这个是显示前20条记录，rownum：是显示行数的列；ID：表TABLENAME的排序字段 阅读全文