title: How to select latest records less than value
body: <p>I have a table named conductor. I want to select latest records that <code>date</code> less than <code>my_value</code>.</p>
  
  <pre><code>+----+-----------+------+
  | id | program   | date |
  +----+-----------+------+
  | 1  | program 1 | 1    |
  | 2  | program 1 | 3    |
  | 3  | program 2 | 3    |
  | 4  | program 1 | 5    |
  | 5  | program 1 | 7    |
  +----+-----------+------+
  </code></pre>
  
  <p>If we consider <code>my_value</code> is 4 then output will be:</p>
  
  <pre><code>+----+-----------+------+
  | id | program   | date |
  +----+-----------+------+
  | 2  | program 1 | 3    |
  | 3  | program 2 | 3    |
  +----+-----------+------+
  </code></pre>
  
  <p>How can I select records by SQL?</p>