This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.

The moose likes EJB and other Java EE Technologies and the fly likes database

A friendly place for programming greenhorns!

Big Moose Saloon

Search | Java FAQ | Recent Topics

Win a copy of The Mikado Method this week in the Agile and other Processes forum!

JavaRanch » Java Forums » Java » EJB and other Java EE Technologies

Author

database

sak sha
Greenhorn

Joined: May 02, 2006
Posts: 3

posted

0

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

Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3652

I like...

Eclipse IDE

Flex

Google Web Toolkit

posted

0

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

My Blog: Down Home Country Coding with Scott Selikoff

I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.

subject: database