eBay Interview Question | Male Employee
Question
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways
Answer ( 1 )
SEELCT Employee Name , Gender ,CASE WHEN Gender =’Female’ then (Select salary from employees table order by Salary DESC limit n-1,1)ElSE (Select salary from employees table ,order by Salary DESC ,limit n+1,1) END as Salary
FROM Employees Table ;