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

Answer Posted / vivek dubey

select salary_column from salary_table
where rownum<4
order by salary_column desc

Is This Answer Correct ?    24 Yes 42 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is replication id?

524


What does the hierarchical profiler does?

570


Is sql developer case sensitive?

522


What is left join in sql?

586


What is benefit of creating memory optimized table?

544






What is t sql in sql server?

572


What are primary key and foreign key and how they work?

556


How do I find sql profiler?

522


how would you get the current date in mysql? : Sql dba

553


How much does sql certification cost?

550


Is sqlite good enough for production?

536


what is an index? : Sql dba

529


Is there any restriction on the use of union in embedded sql?

683


What is trigger in pl sql with examples?

525


Compare sql & pl/sql

612