title: Max date in an nHibernate HQL query
body: <p>I am having some difficultly writing an hql query that will search a table for all the rows where certain criteria are met but I only want to return the row with the max date.</p>
  
  <p>For example the where clause of the query would be something like:</p>
  
  <p>column1 = input1 and column2 = input2 and date_column &lt; date_input</p>
  
  <p>This might return several rows with different dates but I am only interested in the one with the latest date.  I also need it to return the entire row.</p>
  
  <p>Presently, I am executing the query with the criteria above ordered descending by date and then fetching the first item in C#.  I would like to have an hql query or iCriteria solution that can do this in one step if possible.</p>