Write a query to find second highest salary of an employee.
Answer Posted / jeff
select max(salary)
from Emp
where rownum < 2;
| Is This Answer Correct ? | 3 Yes | 19 No |
Post New Answer View All Answers
What are sql procedures?
what does myisamchk do? : Sql dba
What is a call statement? Explain with an example.
How to sort the rows in sql.
What is structural independence and why is it important?
Can you join views in sql?
What are the different types of functions in sql?
What does (+) mean in sql joins?
Why we use sql profiler?
How many scalar data types are supported in pl/sql?
What is sql engine in oracle?
What is execution plan in sql?
What is dml and ddl?
What are two statement types in sql?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure