ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: Sorted results not expected
Date Thu, 22 Mar 2007 11:48:37 GMT
Probably the subselect, move that to the outer select statement and
see if it works.

Larry


On 3/22/07, Tony Jang <guangquanzhang@gmail.com> 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 &lt;= #endRow#
>                          order by lastupdatetime desc)
>          WHERE rno &gt;= #startRow#
>

Mime
View raw message