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

Home -> Community -> Usenet -> c.d.o.server -> selecting records

selecting records

From: G. Kakisina <ivkaki_at_hvision.nl>
Date: Tue, 26 Jan 1999 13:06:01 +0100
Message-ID: <78kb1f$9dm$1@freyja.bart.nl> 





Hi,



I want to select several records using rownum. This works fine but it doesnt
work properly with 'ORDER BY'. It doesn't show the records i want.
For example; I want to select the ten newest records from my table. The
table contains a date field.


How can i do this?



G. K.


Received on Tue Jan 26 1999 - 06:06:01 CST












Original text of this message













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