How do I select just the top 10 records from the result of a select after it includes the order by descending? I tried using where rownum <= 10 but it gives the top 10 before the "desc" on the order by clause. Here is my current select statement.
SELECT PD_EVENT.EVENT_CODE, PD_EVENT.EVENT_DATE, PD_EVENT.EVENT_LOCATION, PD_EVENT.EVENT_OUTCOME, PD_EVENT.FILE_NUM
ORDER BY PD_EVENT.EVENT_DATE DESC
I also thought about possibly creating a view with all the records and then performing a Top 10 on the view but was hoping there would be a better solution.