Top ten

We often want to know the top 1, 2, 10 or whatever values from a query. This is dead simple in MySQL. However many JOINs and WHEREs the query has, simply ORDER BY the column(s) whose highest values are sought, and LIMIT the resultset:



  SELECT (somecolumn), (othercolumns) ...

  FROM (some tables) ...

  ORDER BY somecolumn DESC

  LIMIT 10;