title: Convering Select Statement into Update Statement
body: <p>I'm using this query to pull a certain row (2) from 6 results but I want to run a update query on the title on row (2) from 6 results of data.</p>
  
  <p>Do I have to use a UNION? I don't know how to write the query.</p>
  
  <pre><code>with cte as
  (
      Select Title, Title_Row = ROW_NUMBER() OVER (ORDER BY ID ASC)
      From products.features
      where productid = '172'
  )
  select Title
  from cte
  where Title_Row = 2
  </code></pre>
  
  <p>thanks</p>