Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Query

 
Diwakar
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Can anyone provide me with an sql query using which I could find out the first employee details who has the second highest salary in Emp table.
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Diwakar,
Yes, I can supply you with the SQL query you require (assuming it is for an Oracle database), but it seems that this is a homework assignment. If so, then perhaps you would care to explain to me why I (or someone else) should do your homework for you.

Good Luck,
Avi.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34422
347
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Diwakar,
If you haven't seen Mark's note yet, please update your last name do more than an initial.

Regardless of whether this is a homework assignment, the key is to start building the query in little pieces.

Do you know how to write a SQL query to find out the highest salary? The second highest salary? The employee with a specific salary? Post some of these and then we can work with you to merge them into the query you need. Or you may find that the query writes itself at that point. Or if you get stuck on one of these, we can point you in the right direction.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic