Order by in exists sub query

Question

When I execute below query I give this error:

ORA-00907: missing right parenthesis

error hint to like.

select *
from image img, imageinfo info 
where
   img.i_id = info.i_id and
   (info.i_state like 'delete%' or
    exists (select * from back bk where rownum = 1 order by bk.b_date desc)
   )

Answer 1

Remove order by clause from your exists clause