Probably the subselect, move that to the outer select statement and
see if it works.
Larry
On 3/22/07, Tony Jang <[EMAIL PROTECTED]> wrote:
hi all
I used ORDER BY to get sorted results, but why is it not my expect results?
My database is ORACLE 9.
Any help will be appreciated
Below is my sql statement:
SELECT *
FROM (select rownum rno, a.a aa, a.b
ab, a.c ac, b.a ba, b.b bb, b.c bc, b.d bd,a.d ad,
a.lastupdatetime lastupdatetime, d.a da
from table1 a, table2 b, table3 c, table4 d
where a.id = c.id and a.x = 1
and a.y = 1 and c.z = 1
and a.sid = b.sid and a.id = #custID#
and a.sid = d.sid and ROWNUM <= #endRow#
order by lastupdatetime desc)
WHERE rno >= #startRow#
