title: Select the SECOND LAST record in each group
body: <p>There is a table <code>Remark</code> that contains data as shown below:</p>
  
  <pre><code>       SerialNo | RemarkNo  | Desp
  =============================================
               10 |         1 | rainy
               10 |         2 | sunny
               11 |         1 | sunny
               11 |         2 | rainy
               11 |         3 | cloudy
               11 |         4 | sunny
               12 |         1 | rainy
  </code></pre>
  
  <p>What query will return the following result:</p>
  
  <pre><code>             10 |         1 | rainy
               11 |         3 | cloudy
               12 |      null | null
  </code></pre>
  
  <p>That is, the second last record in each group should be returned?</p>
  
  <p>Assuming all the RemarkNo for a SerialNo are continuous. The larger the remark number, the later the remark was made. Hence, the second last RemarkNo for SerialNo 10 is 1 with Desp 'rainy'.</p>