Write a query to find second highest salary of an employee.
Answer Posted / gyana ranjan behera
select ename,sal.rn from(select ename,sal,rownum rn from(select ename,sal from emp order by sal desc))where rn=2;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are user defined functions?
Explain what is a column in a table?
What is difference between hql and native sql?
Is it possible to read/write files to-and-from PL/SQL?
Can a trigger call a stored procedure?
what are rollup and cube in t-sql? : Transact sql
How do you delete duplicates in sql query using rowid?
Explain clause in sql?
how to use myisamchk to check or repair myisam tables? : Sql dba
Why do we use %rowtype & %type in plsql?
How do I run a query in pl sql developer?
What types of commands can be executed in sql*plus?
When do we use triggers?
How do you update a table in sql?
how to create a table index in mysql? : Sql dba