how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 33976 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / ashwinee
select empnumber
from emp
where rownmum < 4 and salary in (select salary
from emp
order by salary desc)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Does oracle use sql?
Describe sql comments?
What is a heap in sql?
What is the command used to fetch first 5 characters of the string?
what is a constraint? : Sql dba
How to test for null values?
how to include character strings in sql statements? : Sql dba
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Why cross join is used?
What is varchar example?
what is sp_pkeys? : Transact sql
Is sql pronounced sequel or sql?
What is cross join sql?
What is nvarchar in sql?
What schema means?
