To select with a customer order and limit the results use this command.
SELECT * FROM [table] WHERE [column] ORDER BY [column] ASC LIMIT [value];
You can order by ascending.
Or you can order by descending.
Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
Advanced Programming Made Easy
I hope you enjoyed the article. If I was able to help you please consider buying me a drink.