数据库分页查询语句
可不可以利用rownum来进行分页，比如
select * from tbl_goods t where t.type='服类' and rownum between 1 and 4显示第一页四条记录
select * from tbl_goods t where t.type='服类' and rownum between 5 and 8显示第二页四条记录

[解决办法]
rownum between 5 and 8这个不可以 只能从1到n
select * from(select rownum r,t.* from tbl_goods t where t.type='服类') m where m.r>=4 and m.r<=8试试