var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Second Max Salary
How do we query Second Maximum salary without using Temp Tables.
this is a very, very common homework question, so we cannot answer it directly for you, but we can help you discover the answer for yourself
you can do this with a subquery -- the second highest salary can be determined using MAX(salary), where the salaries aren't the highest salary