title: File Extension query in Oracle/Sql
body: <p>I have a table tblAttachmentDetails which contains ID,FileName &amp; LastUpdated.</p>
  
  <pre><code>ID    FileName     LastUpdated
   1    Abc.txt      12/12/2011
   2    dsa.doc      12/12/2008
   3    ddd.xls      12/12/2003
   4    Accbc.xlsx   12/12/2006
   5    cc.txt       12/12/2006
   6    cc.doc       12/12/2006
   7    cc.xls       12/12/2008
   8    cc.xlsx      12/12/2012
  </code></pre>
  
  <p>I want top 10 rows of .xls &amp; .xlsx files order by LastUpdated.</p>
  
  <p>Oracle :</p>
  
  <pre><code>SELECT * 
  FROM tblAttachmentDetails 
  where ROWNUM &lt;= 10 
  and FileName Like '%.xls%' 
  order by LastUpdated Desc
  </code></pre>
  
  <p>Please correct me in this query, because from this query i m only getting  .xls files not xlsx.</p>