I'm trying to achieve the below query with entity query. How WITH Clause is implemented?...WITH EVENTS AS
(select * from EVENTS_ATCS WHERE ROWNUM <10)
select * from EVENTS A
LEFT JOIN ATCS_EVENT_MASTER B ON
(A.TYPEID = B.EventId)
AND
((A.BYTE1 >= B.GE_BYT...