OraFAQ Forum: Server Administration » Limit records returned by a select

Home » RDBMS Server » Server Administration » Limit records returned by a select

Mon, 25 June 2001 10:54

Muriel BRETONNEAU
Messages: 3
Registered: June 2001

Junior Member

Is there a way to limit the number of records
returned by a select ? (Oracle 8.1.6)
Can you send me a sample ?
Thanks
Muriel

Mon, 25 June 2001 19:13

J.S HAN
Messages: 12
Registered: November 2000

Junior Member

Hi.

If you want N rows return.
select *
from table
where rownum <= 5;

rownum is Return row's number.

Previous Topic:	Re: Matrix Query
Next Topic:	Joining multiple tables again!

Goto Forum:

]

Current Time: Mon Dec 23 18:12:30 CST 2024