title: Query to select newly added records only
body: <p>As I am new to mysql, let me clear this doubt. how to write a query to find/select the latest added records only?</p>
  
  <p>Example: 
  Consider a Table, which is daily added certain amount of records. Now the table contain 1000 records. And the total 1000 records are taken out for some performance. After sometimes table is added 100 records. Now I would like take the remain 100 only from the 1100 to do some operation. How to do it? </p>
  
  <p>(For example only, I have given the numbers, But originally I don't know the last updated count and the newly added)</p>
  
  <p>Here My table contain three columns Sno, time, data. where Sno is indexed as primary key.</p>
  
  <p>Sample table:</p>
  
  <pre><code>| sno | time                | data    |
  
  |   1 | 2012-02-27 12:44:07 |     100 |
  
  |   2 | 2012-02-27 12:44:07 |     120 |
  
  |   3 | 2012-02-27 12:44:07 |     140 |
  
  |   4 | 2012-02-27 12:44:07 |     160 |
  
  |   5 | 2012-02-27 12:44:07 |     180 |
  
  
  |   6 | 2012-02-27 12:44:07 |     160 |
  
  |   7 | 2012-02-28 13:00:35 |     100 |
  
  |   8 | 2012-03-02 15:23:25 |     160 |
  </code></pre>