how to retrieve the top 3 salaries of the table using rownum

Answer Posted / saisravanthi

select salary from
(select salary,rownum from salary_tab
order by salary_tab desc)
where rownum < 4;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does one use sql*loader to load images, sound clips and documents? : aql loader

677


What is sql character function?

546


What are sql injection vulnerabilities?

500


How do I view tables in mysql?

546


What does a pl/sql package consist of?

518






What is on delete set null?

570


Why left join is used in sql?

522


what is the syntax used for partition in tsql? : Transact sql

542


How to write html code in pl sql?

583


How do I access sql anywhere database?

501


Why select is used in sql?

522


Name three sql operations that perform a sort.

593


Can dml statements be used in pl/sql?

581


what is data manipulation language? : Sql dba

533


How do you determine the current isolation level? : Transact sql

584