> Give me the 2 highest salary_amounts (along with the employee_num) in the > department table. > > EMPLOYEE_NUM SALARY_AMOUNT > > 123456 60k > 983474 58K
Again, it's been a while, but I believe the following should work: SELECT * FROM department_table ORDER BY SALARY_AMOUNT FETCH FIRST 2 ROWS ONLY -- Arnoud ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
