Re: Help:about rownum

From: Mike Dwyer <dwyermj_at_co,larimer.co.us>
Date: Fri, 13 Oct 2000 08:07:15 -0600
Message-ID: <ULEF5.23$JY1.9725_at_wdc-read-01.qwest.net>

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 Fri Oct 13 2000 - 16:07:15 CEST