database

May 05, 2006 03:57:00

how to find the second max salary of employee given an emp table using sql

May 05, 2006 05:03:00

Sounds like a homework problem to me. Should be in the JDBC forum too.

Here's a hint: sort the results
Here's another hint: instead of sorting removing the records with the max salary

Hoo hoo hoo! Looks like we got a live one! Here, wave this tiny ad at it:

a bit of art, as a gift, that will fit in a stocking

https://gardener-gift.com