Exercise 5-5

Now You Try It

Human Resources also needs to know the highest salary held for job 3333. Enter an appropriate SELECT statement using a WHERE clause.

The result looks like this:

       (EXPR)
       ------
     30680.00

1 row processed

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

MIN

Use the aggregate function MIN (minimum) to determine the lowest value in a specified column.

How It's Done

Human Resources needs to determine the lowest salary in the company. To obtain this, enter:

select min(salary_amount)
       from position;

The result looks like this:

(EXPR) ------ 2200.00 1 row processed