Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ** SQL WHERE clause order
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
Received on Tue Nov 04 2003 - 15:34:27 CST
![]() |
![]() |