Link to home
Start Free TrialLog in
Avatar of srikotesh
srikotesh

asked on

how to modify the below sql query

Hi Experts,

how do i change or condition in the below query?
is there any alternative instead of or?
i have to convert this sql query to hibernate hql.
SELECT t.Name, t.ID FROM master t WHERE t.ID IN (3699,3700)  AND (Parent_ID IS NULL OR Parent_ID='0')
ASKER CERTIFIED SOLUTION
Avatar of Walter Ritzel
Walter Ritzel
Flag of Brazil image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of srikotesh
srikotesh

ASKER

Excellent