Find out the 3rd highest salary?
Answer Posted / dharmendra yadav
select min(salary) from (select name , salary , rownum from
Emp order by salary desc) where rownum <= 3 ;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can dml statements be used in pl/sql?
Explain ddl statements in pl/sql?
how many tables will create when we create table, what are they? : Sql dba
Which are sql * plus commands?
What is sql table?
What are the different types of triggers?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Can you select everything, but 1 or 2 fields, without writer's cramp?
Which command is used to call a stored procedure?
How do I use google cloud in sql?
How many joins can you have in sql?
Should I use mbr or gpt?
How many clustered indexes can be created on a table?
Explain exception handling in pl/sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba