Using the Oracle dialect, IDEA redlines rownum usage below and gives this error message: nexpected 'rownum', ';' expected SELECT m.dma_description FROM markets m, dealer_leads l WHERE l.dma=m.dma AND rownum = 1 AND l.owner_id=? AND report_month=?