return penultimate value : <p>Is it possible to return the penultimate record of a field? I want to do a select that would return me 2 ... Always the second but last record of the field</p>

<p>I use</p>

<pre><code>select top(1) u_lastdado from (select top 2 u_lastdado from cl order by u_lastdado desc ) t order by u_lastdado asc
</code></pre>

<p>but doesn't work. He continues to give me the present value and not the old</p>

<p>Example</p>

<pre><code>select u_lastdado from cl where u_lastdado&lt;&gt; ''
</code></pre>

<blockquote>
  <p>u_lastdado</p>
  
  <p>243237000<br> 213968131</p>
</blockquote>

<pre><code>update cl set u_lastdado=213968126 where nome ='Eira e Beira, lda'
</code></pre>

<blockquote>
  <p>u_lastdado</p>
  
  <p>243237000<br> 213968126</p>
</blockquote>

<p>I need to know how to go get the '213968131' that was formerly
I use SQL SERVER 2012</p>
