oracle 分页查询

水果表：

CREATE TABLE fruits
(
  f_id  char(3),  
  s_id  number(4),
  f_name varchar2(20),
  f_price number(4,1)
) ;


水果数据：

INSERT INTO fruits VALUES('a1', 101,'apple',5.2);
INSERT INTO fruits VALUES('b1',101,'blackberry', 10.2);
INSERT INTO fruits VALUES('bs1',102,'orange', 11.2);
INSERT INTO fruits VALUES('bs2',105,'melon',8.2);
INSERT INTO fruits VALUES('t1',102,'banana', 10.3);
INSERT INTO fruits VALUES('t2',102,'grape', 5.3); 
INSERT INTO fruits VALUES('o2',103,'coconut', 9.2);
INSERT INTO fruits VALUES('c0',101,'cherry', 3.2);
INSERT INTO fruits VALUES('a2',103, 'apricot',2.2);
INSERT INTO fruits VALUES('l2',104,'lemon', 6.4);
INSERT INTO fruits VALUES('b2',104,'berry', 7.6);
INSERT INTO fruits VALUES('m1',106,'mango', 15.6);
INSERT INTO fruits VALUES('m2',105,'xbabay', 2.6);
INSERT INTO fruits VALUES('t4',107,'xbababa', 3.6);
INSERT INTO fruits VALUES('m3',105,'xxtt', 11.6);
INSERT INTO fruits VALUES('b5',107,'xxxx', 3.6);

查询水果类表价格第8-第15的水果信息

select rn 序号, f_name 名称, f_price 价格 from (select rownum rn, f_name, f_price from (select f_name, f_price from fruits order by f_price desc)) where rn <= 15 and rn >= 8;