How to get employee name from employee table which is the
fiveth highest salary of the table
Answer Posted / shashidhar
SELECT EMP_NAME (SELECT ROWNUM R,B.* FROM employee B ORDER
BY SALARY DESC) A
WHERE A.R = 5
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to return an array from java to pl/sql?
What is the difference between the sql*loader and import utilities? : aql loader
How do I count records in sql?
what is error ora-03113: end-of-file on communication channel?
What are the operators in sql?
How do I create a sql database?
How do I make sql search faster?
what is column? : Sql dba
What is a temp table?
How to use boolean type in select statement?
Why do we use procedures in sql?
How can you fetch first 5 characters of the string?
What is the difference between sql, mysql and sql server?
what are local and global variables and their differences? : Sql dba
Is natural join and inner join same?