Comparison Relational Operators Symbol 1 Operator Equal To

Comparison Relational Operators

Symbol 1 = Operator Equal To 2 > Greater Than 3 >= Greater Than or Equal To 4 < Less Than 5 <= Less Thanor Equal To 6 <> Not Equal To Examples What It Means DEPARTMENT Select all employees in the Research Department “Research” SALARY >40000 SALARY >=40000 SALARY <=40000 DEPARTMENT <>"Research" Select all employees who make more than$40, 000 Select all employees who make $40, 000 or more Select all employees who make less than$40, 000 Select all employees who make $40, 000 or less Select all employees in any department other thanthe Research Department

NOT LOGICAL OPERATOR Operator 1 NOT Examples Not Equal To DEPARTMENT NOT “Research” What It Means Select employees in any department other thanthe Research Department

OR LOGICAL OPERATOR Operator Example DEPARTMENT 1 OR “Finance” OR “Accounting ” What It Means Select all employees in the Finance Departmentand select all employees in the Accounting Department

OR LOGICAL CONDITION Operator Example What It Means DEPARTMENT “Finance” “Accounting ” Select all employees in the Finance Department and select all employees in the Accounting Department

AND LOGICAL CONDITION Operator 1 Example What It Means DEPARTMENT SALARY “Research” <40000 Select all employees in the Research Department who also make less than $40 , 000