CIBC Interview Question

How will you extract a reapiting outcoume through SQL?