how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 36962 Views
- Oracle, I also Faced
- E-Mail Answers
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 can we make an if statement within a select statement?
how can we know the count/number of elements of an array? : Sql dba
what is sql server agent? : Sql dba
what is log shipping? : Sql dba
When do we use triggers?
What is the difference between subquery and correlated query?
what is the stuff function and how does it differ from the replace function? : Sql dba
Is inner join same as self join?
Can a trigger call a stored procedure?
What does select count (*) mean in sql?
what are the t string functions available in tsql? : Transact sql
What are all the different types of indexes?
What is a composite primary key?
how to use regular expression in pattern match conditions? : Sql dba
How can I make sql query run faster?
