Limit for oracle

MySql

SELECT periodo FROM ipc WHERE cierre = ’si’ ORDER BY periodo DESC limit 1

Oracle (malo)

SELECT periodo FROM ipc WHERE cierre = ’si’ AND rownum = 1 ORDER BY periodo DESC

Oracle (bueno)
select * from ( SELECT periodo FROM ipc WHERE cierre = ’si’ ORDER BY periodo DESC ) where rownum = 1