Hi, I am trying to get the 2 highest value of numeric column using SQL. I used to do this in QMF on mainframe but am not sure how to it in SQL.
Has anyone ever experimented with this kind of queries? For example: Give me the 2 highest salary_amounts (along with the employee_num) in the department table. EMPLOYEE_NUM SALARY_AMOUNT 123456 60k 983474 58K Amir _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
