title: SQL most recent using row_number() over partition
body: <p>I'm working with some web clicks data, and am just looking for the most recent page_name with the user_id visited (by a timestamp).  Using the below code, the user_id is repeated and page_name with shown, with sorted descending.  However, I would just like recent_click always = 1.   The query when complete will be used as a subquery in a larger query.    </p>
  
  <p>Here is my current code:</p>
  
  <pre><code> SELECT user_id,
   page_name,
   row_number() over(partition by session_id order by ts desc) as recent_click
   from clicks_data;
  
   user_id |  page_name  |  recent_click
   --------+-------------+--------------
   0001    |  login      |  1
   0001    |  login      |  2
   0002    |  home       |  1
  </code></pre>