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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get the first 10 records(with order by)?

Re: How to get the first 10 records(with order by)?

From: Gerald Anleitner <ga_at_phil.uni-passau.de>
Date: Mon, 4 Oct 1999 10:35:37 +0200
Message-ID: <37f8671b.0@news.rz.uni-passau.de> 





> I can use "select first 10 * from orders order by saledate" to get


the


> first 10 records,and how to do this in oracle?


as far as i know, this feature is not supported by oracle (in fact,
it's not in sql92 as well). sqlserver and db/2 support it even
though...



bye,


g


Received on Mon Oct 04 1999 - 03:35:37 CDT












Original text of this message













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