I am currently working on a multiple query assignment that is asking for the second to least value in a field. How would I go about this?

There are several variations on this, but here is one using the DB2 sample database:

with T (emp_salary, row_num)
as (select salary, row_number() over (order by salary asc) from employee)
select emp_salary from T where row_num = 2"

Hmmm...I'm afraid that's a little over my head, but I have realized I have a bigger problem that needs fixing before I move onto that. Thanks for the help tho.

I am trying to display rows that are only less than the average of one column divided by another.

So:

SELECT COLUMN A, COLUMN B, COLUMN C / COLUMN D
FROM TABLE
WHERE (COLUMN C / COLUMN D) < AVG (COLUMN C / COLUMN D)

is what I have right now, though I realize the MIN (COLUMN C / COLUMN D) is impossible. How would you perform this type of query?

Thanks in advance.

select * from employee
where bonus / salary < (select avg(bonus / salary) from employee)

Thank you so much Marcus. Much appreciated!