Using Conditional Retrieval › Using Comparison Operators in Predicates › Exercise 4-1

Exercise 4-1

Now You Try It

The manager of the Marketing department is looking at a resource plan that assigns employee 5103 to a project coming up. However, the manager doesn't know who employee 5103 is.

Create a SELECT statement to retrieve all rows in the EMPLOYEE table that have an employee with an ID of 5103. Display employee ID and first and last name.

The result looks like this:

EMP_ID  EMP_FNAME             EMP_LNAME
------  ---------             ---------
  5103  Adele                 Ferguson

1 row processed

If your results do not match what you see above, check Review Answers for Chapter 4 for the correct SQL syntax.

Why do you see only one row?

The employee ID is a unique key, so there is only one employee with this ID.