Re: Getting first/last record

In a relational database there is no concept of first and last record. For any given query there will be, of course, the first record returned and the final record returned, but it is entirely based on the query not on the table. In addition, there is also no concept of an ordered table. It is possible to load a table from data that is sorted and in many cases if you perform a simple query (i.e. select * from table1;) you will get it back in the same order, but to some degree that is coincidence.

Ken

STEVE wrote:

> 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 Thu Jul 15 1999 - 07:04:08 CDT