To list a baker's top three donut buyers:
SELECT customer,units_ytd FROM (SELECT customer,units_ytd FROM customers ORDER BY units_ytd desc) WHERE ROWNUM < 4; CUSTOMER UNITS_YTD ----------------------- --------- Safeway 102,853 Nob Hill 81,964 Albertsons 75,692