|
-
This will get you the second one. If you want the both the first and second, change it to <=2. Also, since you did not list all the fields in the SELECT, I was unable to remove the QUERY_ROWNUM field from the final resultset:
SELECT
*
FROM
(
SELECT
T.*,
ROWNUM
AS QUERY_ROWNUM
FROM
TABLENAME T
ORDER BY
T.ROWID DESC
)
WHERE
QUERY_ROWNUM = 2
Hope this helps,
- Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|