Sopra Steria interview question

How to calculate second highest marks.

Interview Answer

Anonymous

6 Apr 2015

A join of two tables in a subquery then a third join to find the department second highest and the teacher who taught it.