title: Taking the second last row with only one select in SQL Server?
body: <p>I was trying to select the second last row with SQL Server. So I wrote a query like this:</p>
  
  <pre><code>SELECT TOP 1 * From Cinema 
  WHERE CinemaID!=(SELECT TOP 1 CinemaID 
                   FROM Cinema
                   ORDER BY CinemaID DESC)                      
  ORDER BY CinemaID DESC 
  </code></pre>
  
  <p>and it did what I need. But I want to do the same thing with only one select.</p>
  
  <p>I read that the <em>LIMIT</em> clause in <strong><em>MySql</em></strong> does that. But I couldn't find any equivalent
  of that. So I appreciate any help about finding something useful.</p>