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?

--