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
What is a behavioral trigger?
Explain what is sql?
Can we write ddl statements in functions?
What is pl sql and why it is used for?
explain commit and rollback in mysql : sql dba
How do you modify a table in sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Is keyword pl sql?
What is offset in sql query?
What is parameter substitution in sql?
What is cross join example?
What are schema-level triggers?
Name the operator which is used in the query for pattern matching?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is a constraint?