Re: SQL Select TOP in Oracle

Select * from STUDENTS where DEPT =44 and rownum <11 order by STUID

JF ÐÉÛÅÔ × ÓÏÏÂÝÅÎÉÉ <1323053370%RRZ96.3505$wL5.47074_at_NewsReader> ...
>How do I limit the number of records returned in a select query i.e. in SQL
>Server 7+ the following works
>
>Select Top 10 * from STUDENTS where DEPT =44 order by STUID
>
>Which will return the first 10 students
>
>I've tried looking in Oracle docs and can't find an equivalent to TOP
>Help
>
>JF
>
>
>
Received on Sat Jan 20 2001 - 08:25:18 CST