This week's book giveaway is in the Java 9 forum. We're giving away four copies of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications and have Sander Mak & Paul Bakker on-line! See this thread for details.
The last 10 records that meet some conditions. something like: select startTime, endTime, runStatus from tableName where runStatus = 'successful' The statement above retrieve all the records, but only the newest 10 records is needed, assuming all newly added records are appended to the tail of the table.