title: Query to select max value of a column using max using cassandra
body: <p>We have table called table1 with Tableindex as column. we need the maximum value of tableindex which must result as 3. Consider this table as example(table1), </p>
  
  <pre><code>     Tableindex Creationdate                Documentname    Documentid 
           1      2017-01-18 11:59:06+0530    Document 1      Doc_1
           2      2017-01-18 12:09:06+0530    Document 2      Doc_2
           3      2017-01-18 01:09:06+0530    Document 3      Doc_3
  </code></pre>
  
  <p>In sql, we can select the max value using the following query,<br>
             "<strong>Select max(Tableindex) from table1;</strong>"  // result in 3.</p>
  
  <p>Similarly how can we get the max value in <strong>cassandra query.</strong> Is there Max function in cassandra. If not how can we get the max value?</p>
  
  <p>Thanks in advance.</p>