List ordering from SQL call

Question

i have a List being returned from a daoTemplate.query() call, using a rowMapper. the sql does an order by on a column, happens to be a date column, order by asc when i use the List, am i always guaranteed that the list will be in the order dictated by the sql. can i depend that the first element (theList.get(0)), will ALWAYS be the earliest date(in this case)?

Answer 1

Yes, At the time of execution, the first item will always be the most recent if you are ordering on a date column.