Write a query to find second highest salary of an employee.
Answer Posted / amol londhe
Use the below Query:
Select Max(salary) from Emp
Where Max(salary) < (Select Max(salary) from emp
where emp-no=101);
Is This Answer Correct ? | 10 Yes | 18 No |
Post New Answer View All Answers
what is a cursor? : Sql dba
What is rank dense_rank and partition in sql?
what is the bond code in materialized view?
What are keys in sql?
What is a table in a database?
Explain the select statement in sql?
Explain unique key in sql.
What is difference between hql and native sql?
What is a join?
Can function return multiple values in sql?
What is fmtonly in sql?
What is the use of %rowtype?
What is online transaction processing (oltp)?
How do I order by ascending in sql?
Is left join and outer join same?