Combining Selections and Projections

SELECT Name, Salary

FROM Employee

WHERE Office = ‘Brussels’

SELECT Name, Office, Salary

FROM Employee

WHERE EmpID = 35

Single quotes necessary around text and dates (but not values) in criteria.

Previous slide

Next slide

Back to first slide

View graphic version