I have a simple Cache with 5 fields. One field being a TimeStamp field. In my Java App, how would I query this cache for the following SQL?
Select * from cache where TimeStampField = ( select distinct(max("TimeStampField)) from Cache)
I can't seem to find anything on how to filter like this.
Any help appreciated.
Thanks