From: marsaroid@yahoo.co.uk (marsaroid)
Newsgroups: comp.databases.oracle
Subject: selecting last n records from the table
Date: 6 Jun 2002 06:32:32 -0700
Organization: http://groups.google.com/
Lines: 4
Message-ID: <34343c2e.0206060532.5aa8c704@posting.google.com>
NNTP-Posting-Host: 64.252.47.109
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1023370353 9975 127.0.0.1 (6 Jun 2002 13:32:33 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 6 Jun 2002 13:32:33 GMT


Is there a way to select the last n records from a table in oracle
based on a criteria. For ex. select * from table where field1 < 100
and rownum < 10. So out of the returned set of the query i just need
the last 10 rows of the returned result instead of all.