Stack Exchange
Stack Overflow
Questions
Tags
Users
About
Stack Overflow
Public
Questions
Tags
Users
About
I want second higest salary so I write below query but the result is "no rows are selected"
Asked
Nov 03 '22 at 15:22
Active
Nov 03 '22 at 15:32
Viewed
30 times
0
SELECT DISTINCT SALARY FROM EMPLOYEES WHERE ROWNUM=2 ORDER BY SALARY DESC;
expected output is 17000
sql
oracle
sql-limit
edited Nov 03 '22 at 15:25
MT0
143,790
11
59
117
asked Nov 03 '22 at 15:22
Faisal
57
5
0 Answers
0