MySQL Forums
Forum List  »  Newbie

Re: Bottom 7 rows, ascending order?
Posted by: Guelphdad Lake
Date: February 13, 2009 06:14PM

laptop gave you the solution but wasn't clear enough

SELECT *
FROM (
  SELECT * 
  FROM
    yourtable
  ORDER BY
    yourcolumn DESC
  LIMIT 7
  ) as derivedtable
ORDER BY 
  1

Options: ReplyQuote


Subject
Written By
Posted
Re: Bottom 7 rows, ascending order?
February 13, 2009 06:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.