Prime is generally utilized With all the Get BY clause, as the purchase of the information just isn't certain Except specified. Top rated and ORDER BY can be used with each other to return the very best or least expensive established of knowledge, i.e., top x or top x p.c of ideal or worst offer