搜索页面的SQL语句

最新推荐文章于 2020-06-23 15:17:45 发布

chaoyv

最新推荐文章于 2020-06-23 15:17:45 发布

阅读量242

点赞数

分类专栏： item02 新蛋

本文链接：https://blog.csdn.net/chaoyv/article/details/84620283

版权

item02 新蛋专栏收录该内容

322 篇文章 0 订阅

订阅专栏

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