Write a query to find second highest salary of an employee.
- 27 Answers
- 21937 Views
- I also Faced
- E-Mail Answers
Answer Posted / versaites
select top 1 emp_total_sal,emp_name from (
select top 2 emp_total_sal,emp_name from employee_table
ORDER BY emp_total_sal DESC) a
ORDER BY emp_total_sal ASC
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is indexes?
What are different types of tables in sql?
Is sql workbench free?
Can instead of triggers be used to fire once for each statement on a view?
How can you know that statistics should be updated?
how to get @@error and @@rowcount at the same time? : Sql dba
What are instead of triggers?
What is a crud api?
What is graph sql?
What is synonyms?
What does dml mean?
what is the difference between a having clause and a where clause? : Sql dba
what is collation? : Sql dba
What is pl sql variable?
Is the primary key an index?
