Actually this will probably give the wrong result as well (if it gives the
correct result it's only by pure luck).
What Oracle does in this case is to get the rows from the inner select
based on the criterias and then sort them according to the order by
clause. The result is that the ROWNUM < #end
Swell, it's still wrong.
This will work.
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,
well, i did not describe in detail: my sql works well in PL/SQL
developer, all results are sorted as expected, but not correctly in my
program
On 3/22/07, Nathan Maves <[EMAIL PROTECTED]> wrote:
Well it looks to me like you are trying to duplicate the built in method to
select a specified numbe
Well it looks to me like you are trying to duplicate the built in method to
select a specified number of rows from a select. If that is the case I
would look into using the partition clause in your sql statement. This is
an Oracle specific command and you can just google for it.
Nathan
On 3/22
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
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.
