title: How to select the entire row where the row id is the maximum
body: <p>I'm trying to select all columns from my table in the row where the row id is the maximum. Here is my query so far.</p>
  
  <pre><code>select * from 
         ( select row_id, max(row_id) over () as max_row_id
         from qa_swab_calendar )
         where row_id = max_row_id;
  </code></pre>
  
  <p>This query returns the desired row but not all columns and I can manually add each individual column like so</p>
  
  <pre><code>   select * from 
         ( select row_id, date, actions, max(row_id) over () as max_row_id
         from duties_calendar )
         where row_id = max_row_id;
  </code></pre>
  
  <p>My question is how can I select all columns for this one row?</p>