I need a fast (efficient) way to retrieve the last record in a table.
I have a table that is used to record real time data. I want to display, on a web page, the last entry made in the table. In other words, the most recently recorded record. While a timestamp field is available, I抦 hoping there is a command or query to get the last record. The tables are very large (some greater than 3 million records) so I need speed.
I have a table that is used to record real time data. I want to display, on a web page, the last entry made in the table. In other words, the most recently recorded record. While a timestamp field is available, I抦 hoping there is a command or query to get the last record. The tables are very large (some greater than 3 million records) so I need speed.