TOP is normally utilized With all the Purchase BY clause, as being the buy of the information is just not confirmed unless specified. Major and ORDER BY can be employed alongside one another to return the best or lowest established of information, i.e., major x or top rated x % of very best or worst