WITH RANK_TBL AS (SELECT FIELD1 AS "ENDING BALANCE", RANK() OVER(ORDER BY FIELD1 DESC) AS "RANK NUMBER" FROM LIBRARY/TABLE) SELECT * FROM RANK_TBL WHERE "RANK NUMBER" < 6 Share Improve this answer Follow edited Nov 12, 2019 at 17:19 lczapski 4,10233 gold badges1717 silver b...