title: SQL - find a table row with the highest number being less than a specified number
body: <p>How can I efficiently find 1 table row that has the highest number in a column that is less than a specified (query) value?</p>
  
  <p><strong>UPDATE</strong>: based on the answer of @Gordon Linoff, then finding 1 table row should be the statement below? Is this the most efficient way? </p>
  
  <pre><code>select * from table1 where colname1 in 
     ( select max( colname1) from table1 where colname1 &lt; 528188000 )
  </code></pre>
  
  <p>@Eric - mostly I am not lazy, at this late I hour maybe I was a bit lazy for a second ;-)</p>