By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,086 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

nth highest salary of the employee

P: 1
i am using

Expand|Select|Wrap|Line Numbers
  1.   delimiter //
  2.    create procedure sp_salary1(ranks int)
  3.    begin
  4.  
  5.    set ranks =ranks-1;
  6.    select * from emp_salary  order by salary desc limit ranks,1;
  7.    end;
  8.  
but i have two person have same salary and display only one person
how to display two person?
Dec 16 '14 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.