title: how to change a value in the last row returned by an sql query?
body: <p>I'm having trouble writing an SQL query that returns rows for which a specific value is put in a field of the last returned row (this modification is only made on the results returned, there must be no modification of the database records).</p>
  
  <p>Here is an example :</p>
  
  <pre><code>SELECT A.a, 
         A.b, 
         A.c
    FROM A
   WHERE A.b = 10
  </code></pre>
  
  <p>Results returned :</p>
  
  <pre><code>A.a |A.b |A.c
  --------------
  1    10   zaza
  2    10   zozo
  3    10   zuzu
  4    10   zozo
  </code></pre>
  
  <p>I would like the request to automatically put a specific value in the A.c field of the last row, such as :</p>
  
  <pre><code>A.a |A.b |A.c
  --------------
  1    10   zaza
  2    10   zozo
  3    10   zuzu
  4    10   XXXX
  </code></pre>