6th last salary
what is the sql query to find 6th 0r 7th largest salary from the table?Also where r SQL table rare created?
Posted Answers
I have not tested them -
select salary from employee e1 where (n-1)=(select count(*)
from employee where salary > e1.salary )
unfortunately I am not able to understand that "rare" thing. Can u please explain me more, what are you asking ?
Answer by: coders2020