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
What are the rules to be applied to nulls whilst doing comparisons?
How do you write a subquery?
Why is partition used in sql?
Can you have more than one trigger on a table?
Which normal form is best?
What is a column in a table?
What is loop in pl sql?
What are different types of functions in sql?
What is difference between rank () row_number () and dense_rank () in sql?
how many sql dml commands are supported by 'mysql'? : Sql dba
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What are pl sql data types?
What are the operators in sql?
Why stored procedures are faster than query?
How do I enable sql encryption?