selecting last n records from the table
From: marsaroid <marsaroid_at_yahoo.co.uk>
Date: 6 Jun 2002 06:32:32 -0700
Message-ID: <34343c2e.0206060532.5aa8c704_at_posting.google.com>
Date: 6 Jun 2002 06:32:32 -0700
Message-ID: <34343c2e.0206060532.5aa8c704_at_posting.google.com>
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. Received on Thu Jun 06 2002 - 15:32:32 CEST