rrudnik
7/1/2015 - 2:01 PM

limit data with ROWNUM, workaround for ROWNUM pseudo column with inline view.

limit data with ROWNUM, workaround for ROWNUM pseudo column with inline view.

limitData.sql
content_copyfile_download
SELECT ROWNUM, INVOICE_ID, ACCOUNT_NUMBER
FROM (SELECT INVOICE_ID, ACCOUNT_NUMBER
FROM INVOICES ORDER BY INVOICE_DATE)
WHERE ROWNUM <= 3;