how to find the second highest salary from emp table?
Answer Posted / shivdas suryawanshi
select salary from emp where salary=(select max(salary)
from emp where salary < (selct max(salary) from emp));
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is blind sql injection?
What is cursor in pl sql with examples?
Is primary key is clustered index?
How many types of privileges are available in sql?
How bulk collect improves performance?
What is the life of an sql statement?
Can you call pl/sql package functions from within a fast formula?
How does left join work in sql?
What are sql commands?
What is hibernate and its relation to sql?
How to install oracle sql developer?
What is faster join or subquery?
Does sql use python?
What is cursor and its types?
What is rowid in sql?