ORACLE: Limit Returned records with rownum

The following query will get the latest entered_on date from the result table.   — This select will get the latest result entered_on date — to check after a refresh what’s the latest data — SELECT * FROM ( your_query_here ) WHERE ROWNUM <= N. select * from (select entered_on from result where trim(entered_on) is […]