Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 42831 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / seema
select sal from (select distinct sal from emp order by sal
desc ) where rownum < 3;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is %type in pl sql?
What are basic techniques of indexing?
How to test for null values?
How does stored procedure reduce network traffic?
What is nvl?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is the maximum rows in csv?
What are records give examples?
what is the functionality of the function htmlentities? : Sql dba
What is difference between left and right outer join?
What is bulk collect in pl sql?
Write a sql query to get the third highest salary of an employee from employee_table?
What does varchar include?
How do I access sql anywhere database?
