Snippet Name: WHERE Clause: Conditions Description: The WHERE Clause servers two different purposes. One is to limit the records affected by a DML statement. Also see:» BETWEEN Condition » LIKE Condition » Combining the AND and OR Conditions » OR Condition » AND Condition » WHERE Clause: Joins » Having Clause Comment: (none) Language: Highlight Mode: PLSQL Last Modified: March 07th, 2009
Description: The WHERE Clause servers two different purposes. One is to limit the records affected by a DML statement.
Also see:» BETWEEN Condition » LIKE Condition » Combining the AND and OR Conditions » OR Condition » AND Condition » WHERE Clause: Joins » Having Clause
SELECT sal FROM emp WHERE deptno = 30;