Query to find the 10th maximum salary from an employees table which contains empno,empname,empsal as columns.If this table contains n number of records,how to determine the 10th maximum salary
superhuman
0
Newbie Poster
campkev
0
Posting Pro in Training
there's probably a more efficient way but this should work
select max(empsal) from employees where empno not in (select top 3 empno from employees order by empsal desc)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.