SELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro1') OR
(pro_name = 'pro4') OR
(pro_name = 'pro5') OR
(pro_name = 'pro11') OR
(pro_name = 'pro10') OR
(pro_name = 'pro2') OR
(pro_name = 'pro3') OR
(pro_name = 'pro6') OR
(pro_name = 'pro7') OR
(pro_name = 'pro8') OR
(pro_name = 'pro9') OR
(pro_name = 'pro12')我想实现 结果按pro1,pro4,pro5,pro11,pro10,pro2,pro6,pro7,pro8,pro9,pro12 怎么实现 这语句呢 求教了。
FROM product
WHERE (pro_name = 'pro1') OR
(pro_name = 'pro4') OR
(pro_name = 'pro5') OR
(pro_name = 'pro11') OR
(pro_name = 'pro10') OR
(pro_name = 'pro2') OR
(pro_name = 'pro3') OR
(pro_name = 'pro6') OR
(pro_name = 'pro7') OR
(pro_name = 'pro8') OR
(pro_name = 'pro9') OR
(pro_name = 'pro12')我想实现 结果按pro1,pro4,pro5,pro11,pro10,pro2,pro6,pro7,pro8,pro9,pro12 怎么实现 这语句呢 求教了。
解决方案 »
- vs08开发的web在windows mobile里fileupload控件无法预览图片的问题,图片无法预览,上传出错,这个怎么解决,这程序在ie8.0也是不行
- 高手帮我 关于个性化属性的问题
- 如何使用编辑器
- 怎样在GRIDVIEW实现具体页面搜索的功能???
- 钱币的大小写转换有做过的吗123 成一百二十三元整
- |M| 如何在我的类中return 掉当前的操作
- 高分求图片缩小的程序或控件
- dbhelper获取sql存储过程返回值的问题
- 如何對綁定后的控件定義事件???????在綫等。。。。
- 我还有3000多分!!!重分求Visual Studio.NET 中文正式版!!!!
- Conversion failed when converting datetime from character string.
- 求个正则表达式
FROM product
WHERE pro_name in('pro1','pro4','pro5','pro11','pro10','pro2') order by pro_name
FROM product
WHERE pro_name in (pro1,pro4,pro5,pro11,pro10,pro2,pro6,pro7,pro8,pro9,pro12)
SELECT id, pro_name, img, title, content, pub_date FROM product WHERE pro_name IN ('pro4','pro5','pro11'.....)我想实现 结果按pro1,pro4,pro5,pro11,pro10,pro2,pro6,pro7,pro8,pro9,pro12 怎么实现 这语句呢
这个是在不知道楼主什么意思
union SELECT * FROM product WHERE pro_name = 'pro4'
union SELECT * FROM product WHERE pro_name = 'pro5'
union SELECT * FROM product WHERE pro_name = 'pro11'
union SELECT * FROM product WHERE pro_name = 'pro10'
union .....
刚发完贴就到6楼了
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro1'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro4'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro5'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro11'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro10'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro2'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro3'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro6'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro7'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro8'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro9'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro12'
FROM product
WHERE pro_name in ('pro1','pro4','pro5','pro11','pro10','pro2','pro6','pro7','pro8','pro9','pro12')
排序有什么规律么
FROM product
WHERE (pro_name = 'pro1') OR
(pro_name = 'pro4') OR
(pro_name = 'pro5') OR
(pro_name = 'pro11') OR
(pro_name = 'pro10') OR
(pro_name = 'pro2') OR
(pro_name = 'pro3') OR
(pro_name = 'pro6') OR
(pro_name = 'pro7') OR
(pro_name = 'pro8') OR
(pro_name = 'pro9') OR
(pro_name = 'pro12') order by pro_name = 'pro1','pro4','pro5','pro11','pro10','pro2','pro3','pro6','pro7','pro8','pro9','pro12' (写的是错误的) 这里的 pro_name 就是产品类别,就是在查询结果里把同一类的显示完,再显示下一个类别
想实现 显示完pro1的所有产品,再显示pro5的所有产品,再显示pro11的所有产品 最好显示pro12的产品类别 以上的我都试过了 显示按pro1,pro10,pro11显示了
FROM product WHERE pro_name = 'pro1'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro4'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro5'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro11'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro10'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro2'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro3'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro6'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro7'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro8'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro9'
union
SELECT id, pro_name, img, title, content, pub_date
FROM product WHERE pro_name = 'pro12'
群号:29037453
FROM product
WHERE pro_name in ('pro1','pro4','pro5','pro11','pro10','pro2','pro6','pro7','pro8','pro9','pro12')ORDER BY
CHARINDEX(','+STUFF(pro_name,1,3'')+',',','+1,4,5,11,10,2,6,7,8,9,12'+',')
FROM product
WHERE pro_name in ('pro1','pro4','pro5','pro11','pro10','pro2','pro6','pro7','pro8','pro9','pro12')ORDER BY
CHARINDEX(','+STUFF(pro_name,1,3,'')+',',','+'1,4,5,11,10,2,6,7,8,9,12'+',')
SELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro1') OR
(pro_name = 'pro4') OR
(pro_name = 'pro5') OR
(pro_name = 'pro11') OR
(pro_name = 'pro10') OR
(pro_name = 'pro2') OR
(pro_name = 'pro3') OR
(pro_name = 'pro6') OR
(pro_name = 'pro7') OR
(pro_name = 'pro8') OR
(pro_name = 'pro9') OR
(pro_name = 'pro12')
--pro1,pro4,pro5,pro11,pro10,pro2,pro6,pro7,pro8,pro9,pro12
Order by
case
when pro_name='pro1' then 1
when pro_name='pro4' then 2
when pro_name='pro5' then 3
when pro_name='pro11' then 4
when pro_name='pro10' then 5
when pro_name='pro2' then 6
when pro_name='pro6' then 7
when pro_name='pro7' then 8
when pro_name='pro8' then 9
when pro_name='pro9' then 10
else 11 end
FROM product
WHERE pro_name in ('pro1','pro4','pro5','pro11','pro10','pro2','pro6','pro7','pro8','pro9','pro12')ORDER BY
CHARINDEX(','+STUFF(pro_name,1,3,'')+',',','+'1,4,5,11,10,2,6,7,8,9,12'+',') 请教:access中 CHARINDEX得改成instr 怎么写呢
SELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro1')
unionSELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro2')
unionSELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro3')
unionSELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro4')
unionSELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro5')
unionSELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro6')
union
group by id, pro_name, img, title, content, pub_date
SELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro1')
unionSELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro2')
unionSELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro3')
unionSELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro4')
unionSELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro5')
unionSELECT id, pro_name, img, title, content, pub_date
FROM product
WHERE (pro_name = 'pro6')group by id, pro_name, img, title, content, pub_date