Hi,

How do we query Second Maximum salary without using Temp Tables.


Kots.

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