DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
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
COMMENT
Name
5+2 =
Submit