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));