Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

Write an SQL query to determine the 5th highest salary without using TOP or limit method.

select min(salary) from (select distinct salary from worker order by salary  desc) where rownum<=5;
Source by www.techbeamers.com #
 
PREVIOUS NEXT
Tagged: #Write #SQL #query #determine #highest #salary #TOP #limit
ADD COMMENT
Topic
Name
3+4 =