title: How to get maximum element from a table from DynamoDb AWS Console?
body: <p>I am trying to create a database table in NoSQL in order to be able to retrieve the element with a maximum value in one of its columns.</p>
  
  <p>Suppose the SQL schema looks like this:</p>
  
  <pre>Table_Page</pre>
  
  <p>PageId: int(10) - PK</p>
  
  <p>Name: varbinary(255)</p>
  
  <p>RevisionId: int(10) - FK</p>
  
  <pre>Table_Revision</pre>
  
  <p>RevisionId: int(10) - PK</p>
  
  <p>Text: varbinary(255)</p>
  
  <p>Rev_TimeStamp: binary(14) </p>
  
  <p><b>How</b> could I design the schema in <b>Amazon DynamoDB Console</b> such that it supports a query to retrieve the page with the latest Revision? Thanks!</p>