Home  >  Forum  >  Database
Post New Query

find second max salary in SQL

joined on
October 10,2013
Asked on October 08,2014
in a list of emplyee i want to find the second max salary without using OPERATOR...??
Thanks in Advance
joined on
March 14,2013
Replied on October 08,2014

Please elaborate your question. Which operator, you are not willing to use?
joined on
October 10,2013
Replied on October 13,2014

I have a list of employee in oracle database using command prompt. My query is I want to display the name of those employee whose have the second max salry in the list but the condition is we do not use mathematical operator i.e. NOT IN etc. Can it is possible through order by or other ?

Write Answer

Copyright ©2017 concretepage.com, all rights reserved |Privacy Policy | Contact Us