I have a scenario like this. There is an employee table with Name and Salary as the fields.
I want to retrieve the second highest salary from this table. I have written a SQL Query like this:
SELECT DISTINCT SALARY FROM EMPLOYEE WHERE ROWID = 2 ORDER BY SALARY DESC.
When i try to run this on SQL/400, its giving an error, which says 'COLUMN ROWID IS NOT SPECIFIED IN THE TABLE'.
Can anyone help. Thanks in advance. Please reply ASAP.