Examples of Search Conditions

SELECT Name, Salary

FROM Employee

WHERE Office IN (‘Brussels’, ‘Tokyo’)

SELECT Name, Office, Salary

FROM Employee

WHERE Salary between 2000 and 3000

SELECT Name, Office, Salary

FROM Employee

WHERE Name Like ‘*am’

SELECT Name, Office, Salary

FROM Employee

WHERE Name Like ‘Ab?’

SELECT Name, Office, Salary

FROM Employee

WHERE Office is Null

SELECT Name, Office, Salary

FROM Employee

WHERE Office NOT IN (‘Toronto’)

Previous slide

Next slide

Back to first slide

View graphic version