搜索页面的SQL语句

SELECT * FROM ( SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM ne_products where ne_introduce like '%双卡双待%' and ne_price>=0 and ne_price<=1000000
 order by ne_products.ne_time desc) A) WHERE RN BETWEEN 1 AND 40 
 
SELECT * FROM ( SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM ne_products where ne_classify_id = 1  and ne_price>=0 and ne_price<=1000000
 order by ne_products.ne_time desc) A) WHERE RN BETWEEN 1 AND 40 
 
SELECT * FROM ( SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM ne_products where ne_brand_id = 1  and ne_price>=0 and ne_price<=1000000
 order by ne_products.ne_time desc) A) WHERE RN BETWEEN 1 AND 40 
 
 

SELECT * FROM ( SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM ne_products where ne_introduce like '%双卡双待%' and ne_price>=0 and ne_price<=1000000
 order by ne_products.ne_number desc) A) WHERE RN BETWEEN 1 AND 40 
 
SELECT * FROM ( SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM ne_products where ne_classify_id = 1  and ne_price>=0 and ne_price<=1000000
 order by ne_products.ne_number desc) A) WHERE RN BETWEEN 1 AND 40 
 
SELECT * FROM ( SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM ne_products where ne_brand_id = 1  and ne_price>=0 and ne_price<=1000000
 order by ne_products.ne_number desc) A) WHERE RN BETWEEN 1 AND 40 
 
 
SELECT * FROM ( SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM ne_products where ne_introduce like '%双卡双待%' and ne_price>=0 and ne_price<=1000000
 order by ne_products.ne_price desc) A) WHERE RN BETWEEN 1 AND 40 
 
SELECT * FROM ( SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM ne_products where ne_classify_id = 1  and ne_price>=0 and ne_price<=1000000
 order by ne_products.ne_price desc) A) WHERE RN BETWEEN 1 AND 40 
 
SELECT * FROM ( SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM ne_products where ne_brand_id = 1  and ne_price>=0 and ne_price<=1000000
 order by ne_products.ne_price desc) A) WHERE RN BETWEEN 1 AND 40