Compound Comparison Search Conditions

SELECT Name, Salary

FROM Employee

WHERE (Office IN (‘Brussels’, ‘Tokyo’) or Salary is Null)and HireDate <= ‘7/15/99’

SELECT Name, Office, Salary

FROM Employee

WHERE (Salary between 2000 and 3000 and Office <> ‘Tokyo’) or (Name like ‘Gor*’ and EmpID > 20)

SELECT Name, Office, Salary

FROM Employee

WHERE Name NOT Like ‘*Abel’ and Salary >= 3100

SELECT Name, Office, Salary

FROM Employee

WHERE Office IN (‘Toronto’) or Name = ‘Anne Abel’

when operators are combined, brackets are evaluated first (inner to outer)

AND means that ALL conditions must be met

OR means that ANY condition may be met

Previous slide

Next slide

Back to first slide

View graphic version