Write a query to find second highest salary of an employee.
Answer Posted / vamana murthy
select ename,salary from emp
where rownum=2
order by salary desc
Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Which command is used to delete a package?
what is a view? : Sql dba
What is write ahead logging in sql server?
what are aggregate and scalar functions? : Sql dba
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is dense_rank?
what are the performance and scalability characteristics of mysql? : Sql dba
What is dba in sql? : SQL DBA
Which is faster truncate or drop?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
Can ddl statements be used in pl/sql?
What is the difference between the conventional and direct path loader? : aql loader
What is pl sql record in oracle?
What is spool?
What is clause?