Hi, In a SQL statement I want a certain where clause to be done first. Is it enough to list it first as follows or do I (and can I) do something else to make it get checked first before other WHERE/AND clause are looked at. Thanks : SELECT emp_id FROM emp WHERE select_sen_emp_chk_first = 'Y' AND dept = :dept AND salary > :min_sal
- Re: ** SQL WHERE clause order A Joshi
- Re: ** SQL WHERE clause order Wolfgang Breitling
- Re: ** SQL WHERE clause order Stephane Faroult
- Re: ** SQL WHERE clause order A Joshi
- Re: ** SQL WHERE clause order A Joshi
- Re: ** SQL WHERE clause order Yong Huang
- RE: ** SQL WHERE clause order Naveen, Nahata (IE10)
- RE: ** SQL WHERE clause order Jamadagni, Rajendra
- RE: ** SQL WHERE clause order A Joshi
- RE: ** SQL WHERE clause order Naveen, Nahata (IE10)
- Re: ** SQL WHERE clause order A Joshi