a query in Oracle Report

when I issue a query in Oracle Report:

1. select * from
2. (
3. select first_name, last_name
4. from students
5. order by first_name
6. )
7. where rownum<3;

I received a warning of missing a ")", if I omit the 5th line, it's fine. should I use a cursor to solve it? Received on Sat Oct 09 2004 - 11:57:45 CDT