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')
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER