Help:about rownum

From: (wrong string) 浙江 <peter_at_aps.com.cn>
Date: Thu, 12 Oct 2000 15:08:42 +0800
Message-ID: <8s3ntn$1gao$1_at_news.cz.js.cn>

Help me:
When I use rownum:
example:
select a,b,c
from table1,table2,table3
[Quoted] [Quoted] 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 Thu Oct 12 2000 - 09:08:42 CEST