I wish to know how to find second highest salary in the employee table . Is it right ?
sql>select max(salary)from(select salary from employee where salary not in(select max(salary)from employee))
Please let me know if there is any better way to do it .
- Thanks ,