我需要是选择两组记录,可需要第一组记录排第一.用集合查询的话不行,应该如何做?请大家指教.
SELECT ARTICLEID, TITLE FROM SCOTT.JYXX_ARTICLE WHERE NCLASSID=2 AND ISTOP='Y' UNION SELECT ARTICLEID, TITLE FROM SCOTT.JYXX_ARTICLE WHERE NCLASSID=2 ORDER BY ARTICLEID DESC
你的语句完全可以改写为效率高的语句, 没有必要用union,你测试一下!
代码语句如下:
SELECT ARTICLEID,
TITLE
FROM SCOTT.JYXX_ARTICLE
WHERE NCLASSID = 2
ORDER BY decode(ISTOP, 'Y', ARTICLEID, null), rownum;
原帖由 wkc168 于 2010-10-15 17:43 发表
SELECT ARTICLEID, TITLE FROM SCOTT.JYXX_ARTICLE WHERE NCLASSID=2
order by decode(ISTOP,'Y', null,ARTICLEID) desc nulls first