Delete comment from: Java67
This question can be solved with and without correlated subquery :
without correlated sub query :
select MAX(score) from Scorecard where score NOT IN (select MAX(score) from Scorecard)
using correlated sub query
select MAX(score) from Scorecard s1 where 2 = (select count(distinct score) from Scorecard s2 where s2.score >= s1.score)
Dec 18, 2014, 2:09:11 AM
Posted to Top 10 Frequently asked SQL Query Interview Questions Answers