-Retrieving last 100 rows by timestamp
Something Something 2011-07-26, 15:20
Need to create a report that shows 'last 100 rows by timestamp'. This query
should return almost instantaneously. Any recommendation regarding the
design? I was thinking of creating a table with 'sequence #' as a key and
value would be 'key of another table that contains the master data'.
Anyway, I will think some more, but if anyone has done something similar, I
would greatly appreciate it if they would share the knowledge. Thanks.