Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help:about rownum
See Turkbear's note on how to apply rownum against the result set.
Mike Dwyer wrote in message ...
Rownum is determined BEFORE the join, not after.
" 㽭" <peter_at_aps.com.cn> wrote in message news:8s3ntn$1gao$1_at_news.cz.js.cn...
Help me: When I use rownum: example: select a,b,c from table1,table2,table3 where table1.a1=table2.b1 and table3=table1.c1 order by a result: a b c 1 ad ds 2 ds sd 21 sad dd 3 lds kd 4 sd sddf now :use rownum select a,b,c from table1,table2,table3 where table1.a1=table2.b1 and table3=table1.c1 and rownum<4 order by a result: a b c 1 ad ds 2 ds sd 4 sd sddf Why???????? how can I get the correct result?
--Received on Sat Oct 14 2000 - 12:00:05 CDT