> > using rownum may not give you the latest mod date record from the all
> > records in the table.
Easy enough to make it do so, though. You just use a sub-query:
SELECT * FROM
( SELECT *
FROM foo
WHERE goo = 'koo'
ORDER BY gooey
)
WHERE rownum < 10
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
