[karthigayini]

use a simple logic
1st find the max sal of entire table
2nd list all sal less than max sal
3rd from that list find the max

select * from table where salary>(select salary from table where salary <max(salary))