title: how to select top 1 data order by date in sql and sqlite
body: <p>My data is like that</p>
  
  <pre><code>Name   code   start_date   end_date    price 
  shop1  7001   2013-01-01   9999-12-31  200 
  shop1  7001   2015-12-01   9999-12-31  300 
  shop1  7110   2015-05-25   9999-12-31  800 
  shop1  7120   2015-05-25   9999-12-31  700 
  shop1  7130   2013-01-01   9999-12-31  300 
  </code></pre>
  
  <p>I would like to select top 1 data order by start_date in all data with one query.</p>
  
  <pre><code>Name   code   start_date   end_date    price 
  shop1  7001   2015-12-01   9999-12-31  300 
  shop1  7110   2015-05-25   9999-12-31  800 
  shop1  7120   2015-05-25   9999-12-31  700 
  shop1  7130   2013-01-01   9999-12-31  300 
  </code></pre>