How to get Max in Jira

Subhajit Bhuiya

I have a simple AO which is HistoricalData and it has 2 columns Date and Count. How can I get Max date programatically from it. I am trying with 

ao.findWithSQL(HistoricalData.class, "DATE", "select max(DATE) from HISTORICALDATA", null);