(
SELECT *
FROM uchome_cbnsns_articles
WHERE idtype = 'blog'
AND TYPE = 'hot'
AND dispose
BETWEEN 1
AND 10
ORDER BY dispose ASC
)
UNION (SELECT *
FROM uchome_cbnsns_articles
WHERE idtype = 'blog'
AND TYPE = 'hot'
ORDER BY tipdateline DESC
) 为什么我这样写出来的顺序是乱的 不是按照我要的来排列的
求高手指点下
第一个select想按照dispose来排序第二个select想按照tipdateline来排列
SELECT *
FROM uchome_cbnsns_articles
WHERE idtype = 'blog'
AND TYPE = 'hot'
AND dispose
BETWEEN 1
AND 10
ORDER BY dispose ASC
)
UNION (SELECT *
FROM uchome_cbnsns_articles
WHERE idtype = 'blog'
AND TYPE = 'hot'
ORDER BY tipdateline DESC
) 为什么我这样写出来的顺序是乱的 不是按照我要的来排列的
求高手指点下
第一个select想按照dispose来排序第二个select想按照tipdateline来排列
(
SELECT *
FROM uchome_cbnsns_articles
WHERE idtype = 'blog'
AND TYPE = 'hot'
AND dispose
BETWEEN 1
AND 10 )
UNION (SELECT *
FROM uchome_cbnsns_articles
WHERE idtype = 'blog'
AND TYPE = 'hot'
) ORDER BY dispose ASC, tipdateline DESC
这样就搞定了
就是这个
liangCK (小梁 爱 兰儿 ?)
- -