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
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is sql character function?
What are sql injection vulnerabilities?
How do I view tables in mysql?
What does a pl/sql package consist of?
What is on delete set null?
Why left join is used in sql?
what is the syntax used for partition in tsql? : Transact sql
How to write html code in pl sql?
How do I access sql anywhere database?
Why select is used in sql?
Name three sql operations that perform a sort.
Can dml statements be used in pl/sql?
what is data manipulation language? : Sql dba
How do you determine the current isolation level? : Transact sql