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 -> Getting first/last record

Getting first/last record

From: STEVE <spectre_at_hkstar.com>
Date: Thu, 15 Jul 1999 10:38:20 +0800
Message-ID: <1duzbw8.194x04mt9r6w8N@[201.1.1.73]> 





Hi,


Being a bit of a newbee, to oracle8 can anybody help with the following.
1.How to get the first record in an ordered table
2 How to get the last record in an ordered table.
the order being on date then time.



In fox pro it's easy, 


set order to date88 (index)


go top


go bottom





steve
Received on Wed Jul 14 1999 - 21:38:20 CDT












Original text of this message













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