title: In MariaDB how do I select the top 10 rows from a table?
body: <p>I just read online that MariaDB (which SQLZoo uses), is based on MySQL. So I thought that I can use ROW_NUMBER() function</p>
  
  <p>However, when I <a href="http://sqlzoo.net/wiki/Self_join" rel="noreferrer">try this function in SQLZoo</a> :</p>
  
  <pre><code>SELECT * FROM ( 
    SELECT  * FROM route
  ) TEST7
  WHERE ROW_NUMBER()  &lt; 10
  </code></pre>
  
  <p>then I get this error :</p>
  
  <blockquote>
    <p>Error: FUNCTION gisq.ROW_NUMBER does not exist</p>
  </blockquote>