find second max salary in SQL




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



Replied on October 08, 2014
Please elaborate your question. Which operator, you are not willing to use?



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










©2024 concretepage.com | Privacy Policy | Contact Us