Fetch second highest cabin cost in SQL

Question:

Fetch second highest cabin cost

Write a query to display the second highest cabin cost rate. Give alias name as SECOND_MAX. 

Code:

Main.sql

select distinct rate as SECOND_MAX
from cabincost
where rate=(select max(rate) from cabincost where rate< (select max(rate) from cabincost));

Recommended: