how to check the 3rd max salary from an employee table?
Answer Posted / gourvendra singh
In oracle you can find the 3rd max salary with the help of
the command:-
select sal from(select sal from(select distinct sal from
emp order by sal desc)
where rownum <=3 order by sal asc) where rownum=1;
Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is procedure in pl sql?
What is a .db file?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is pl sql variable?
What is posting?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
How do you bind variables in pl sql?
What is execute immediate?
What are tuples in sql?
what is a trigger in mysql? Define different types of trigger. : Sql dba
Why truncate is faster than delete?
What is the difference between an inner and outer join?
What is the difference between null value, zero, and blank space?
How many row comparison operators are used while working with a subquery?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?