Hi
I have one column in table called salary, thousand of records in this table.
i need to know first three maxium salary data.
what query i have to written.
Printable View
Hi
I have one column in table called salary, thousand of records in this table.
i need to know first three maxium salary data.
what query i have to written.
if you're using oracle 8+ :
select salary
from (select salary from table order by salary desc)
where rownum <= 3;
Thanks Pipo