posted 10 years ago
This is the table account having two columns name and salary
name salary
A 1000
B 1500
C 1300
D 1200
E 1400
F 1100
ROWNUM NAME SALARY
---------------------------------------
1 B 1500
2 E 1400
3 C 1300
This query returns the Highest three salaries
But when I just want to retrieve top most salary It says No Rows Selected what that means
Tea Addict, Oracle Java Programmer , Oracle SQL Expert , Oracle Java Web Component Developer, Oracle Web Service Developer