MySQL Forums
Forum List  »  General

Re: Anyone can help to find how to solve this.
Posted by: Peter Brawley
Date: June 13, 2019 09:57PM

To get just the first 100 rows ie lowest 100 counts, add LIMIT 100 to the ORDER BY clause.

To get the last hundred rows ie highest 100 counts, change ASC to DESC LIMIT 100.

Options: ReplyQuote


Subject
Written By
Posted
Re: Anyone can help to find how to solve this.
June 13, 2019 09:57PM


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.