Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL Select TOP in Oracle

SQL Select TOP in Oracle

From: JF <john.fitzgerald_at_mainframe.co.uk>
Date: Fri, 19 Jan 2001 16:19:31 -0800
Message-ID: <RRZ96.3505$wL5.47074@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 Fri Jan 19 2001 - 18:19:31 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US