title: How to get Top 25 records order by createdon using SQL query?
body: <p>I have two tables Like updatetext and users I want to top distinct records from updatetext.. Table User having unique records realated to user information and updatetext having multiple updatetext records... I want to get top latest update from updatetext table.. How I can get?  </p>
  
  <pre><code>Users Table
  1) userid
  2) username
  3) password
  4) createdon
  
  UpdateText Table
  1) updatetextID
  2) userid
  3) updateScrap
  4) createdon
  3) location
  </code></pre>
  
  <p><strong>UpdateText</strong>          </p>
  
  <pre><code>updatetextID    userid  updateScrap     Createdon
       11      535     yes good test      2/23/2011 9:59
       12      540    udpate sample       2/23/2011 9:58
       13       44    Absas               2/22/2011 12:30
       14       20    test text 123       2/22/2011 12:24
       15      540    hi how are you?     2/22/2011 12:00
       16      535    Hi r u there?       2/22/2011 12:30
       17      540    welcome back        2/22/2011 10:23
  </code></pre>
  
  <p><strong>User</strong>    </p>
  
  <pre><code>userid  username    password    
  535 abhi        
  540 shankar     
  44  dhaval      
  20  john        
  </code></pre>
  
  <p>I want to get top createdon records from UpdateText Table and
  get username and password from Users table..
  Please help me.</p>