title: DynamoDB secondary sort
body: <p>I'm assessing whether if I can use DynamoDB for our next project, what we are building is quite similar to a blogging platform, here is a simple table</p>
  
  <pre><code>Blog Post
    ID - primary hash key
    Title
    DateCreated - primary range key
    Votes
  </code></pre>
  
  <p>I've read enough to know how to List - list of blog posts, Paging - using last fetched index, Get post details - get a row, I will be sorting using DateCreate, which is my range key.</p>
  
  <p>I'm struggling on how do do sort on a secondary index.  For example, if we have a column called Votes, how do you do Most Votes?  My interpretation is that you can only sort using the range index which I'm already using.</p>