title: SELECT TOP N records by column value
body: <p>For instance, in table id/article/view_counter I would like to select top 5 articles by view_counter.</p>
  
  <p>I could SELECT *, order by view count and then take only first 5 when I loop through array but is there a way to do that directly in query?</p>