SELECT NAME R_NAMEDISPLAY, NBRINV R_NBRREPORT
FROM LQS_INVESTOR
UNION
SELECT 'All Investors' R_NAMEDISPLAY, 0 R_NBRREPORT ORDER BY NAME以上SQl为什么sql-server 可以执行, 在PL-SQl 里面执行就会报错呢?
请问改如何纠正,谢谢!
FROM LQS_INVESTOR
UNION
SELECT 'All Investors' R_NAMEDISPLAY, 0 R_NBRREPORT ORDER BY NAME以上SQl为什么sql-server 可以执行, 在PL-SQl 里面执行就会报错呢?
请问改如何纠正,谢谢!
FROM LQS_INVESTOR
UNION
SELECT 'All Investors' R_NAMEDISPLAY, 0 R_NBRREPORT
from dual
ORDER BY R_NAMEDISPLAY
没有表的时候就象楼上那样 from dual
SELECT NAME R_NAMEDISPLAY, NBRINV R_NBRREPORT
FROM LQS_INVESTOR
UNION
SELECT 'All Investors' R_NAMEDISPLAY, 0 R_NBRREPORT
from dual ) T
ORDER BY T.R_NAMEDISPLAY 这样才能根据R_NAMEDISPLAY 排序。