RE: help with query :)

From: Jamadagni, Rajendra <rajendra.jamadagni_at_espn.com>
Date: Wed, 31 May 2000 09:20:43 -0400
Message-Id: <10514.107279@fatcity.com>

Hi,

The only way to retrieve last rows is to define the meaning of "LAST" first. Is it by pk or any other key? Is it by a maintained timestamp? rule out rowids and rownum <11.

Cheers
Raj

-----Original Message-----
From: Miguel Urosa [mailto:murosa_at_smseuropa.com] Sent: Wednesday, May 31, 2000 6:26 AM
To: Multiple recipients of list ORACLE-L Subject: RE: help with query :)

I think, only you can take last 10 records in a given table if there are still in V$SLQAREA view like insert sentence. Received on Wed May 31 2000 - 08:20:43 CDT