how to find the second highest salary from emp table?
Answer Posted / yash goyal
Select Distinct salary
from employees e
where &no-1=(select count(distinct salary )
from employees
where E.salary < salary);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of triggers exist in pl/sql?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
Why do we use set serveroutput on?
How to select all records from the table?
What is query optimization in sql?
How to take user input in pl sql?
what is a composite key ? : Sql dba
What is Collation Sensitivity ? What are the various type ?
List out the acid properties and explain?
how to write date and time literals? : Sql dba
What is dbo in sql?
What is the purpose of cursors in pl/sql?
how to check server status with 'mysqladmin'? : Sql dba
How many commands are there in sql?
What is coalesce in sql?