Limit on # of return?

[Unna]

I try to select query that will limit the number or records returned, such as 10, how do I make such query? Thanks!

[kmesser]

select * from mytable where rownum < 10;

will return 9 rows.

What are you trying to do?

[pando]

select * from yyy
where rownum < 11

may this is what yuneed...?

[Unna]

thx, they work!