• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database

 
sak sha
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
how to find the second max salary of employee given an emp table using sql
 
Scott Selikoff
author
Saloon Keeper
Posts: 4010
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic