请教一个SQL排序的问题,特急!!!
SQL文如下:
select
TRIM(SUBSTRB(TO_CHAR(T1.A_SUM,'999999999999990.000000000'),1,16)),
TO_CHAR(T1.B_SUM),
TO_CHAR(T1.COUNT_GROUP),
TO_CHAR(T2.COUNT_E),
D_MAX,
T1.F_MAX,
T1.C,
T1.E,
TRIM(SUBSTRB(TO_CHAR(T1.A_SUM,'999999999999990.000000000'),17))
from
(SELECT SUM(A) AS A_SUM,SUM(B) AS B_SUM,COUNT(C) AS COUNT_GROUP,MAX(D) AS D_MAX,TO_CHAR(MAX(F),'YYYYMMDD') AS F_MAX,C,E FROM TABLE1 WHERE G = '1' GROUP BY E,C ORDER BY E,C) T1,
(SELECT E,COUNT(E) AS COUNT_E FROM TABLE1 WHERE G = '1' GROUP BY E ORDER BY E) T2
where
T1.E = T2.E
执行这个SQL,得出的结果集肯定会是按照子查询T1的顺序排序吗?
会不会出现异常情况?原因是什么?
我自己执行的时候,出现过排序错误的情况。