Question:Extract last Two rows of a Query(ROWNUM??)
From: M. N. Kothavale <mnk1623_at_hertz.njit.edu>
Date: 1995/05/01
Message-ID: <1995May1.025959.1428_at_njitgw.njit.edu>#1/1
Date: 1995/05/01
Message-ID: <1995May1.025959.1428_at_njitgw.njit.edu>#1/1
Oracle Gurus:
I need to extract LAST two rows of a specific query. I can NOT use ROWNUM and ORDER BY as oracle number the rows before ordering. Is there any other way I can accomplish this?
Thanks.
- NitiN