select TOP 20 * from table是显示前20行,相当于分页 如果要统计,只要嵌套一下就行了select sum(price) as total_price from ( select TOP 20 * from table【里面是你自己分页的查询语句】) x;