How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 26050 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
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 do I remove all records from a table?
How to select random rows from a table?
What is asqueryable?
define join and explain different type of joins? : Sql dba
What do we need to check in database testing?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
How do you delete data from a table?
what is the difference between undefined value and null value? : Sql dba
What is dcl in sql?
how to drop an existing index in mysql? : Sql dba
Explain what is a view?
How do I sort a table in sql?
What is the trigger in sql?
What does sign mean sql?
What is normalisation and its types?
