Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 27743 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
When do we use triggers?
how many sql ddl commands are supported by 'mysql'? : Sql dba
Explain how exception handling is done in advance pl/sql?
What is structural independence and why is it important?
How does index help in query performance?
What is row_number () in sql?
What is difference between function and trigger?
What are triggers and its types?
What can sql server reporting services do?
What is a sql trace file?
What is sql entity?
Is sql microsoft?
What is memory optimized table?
Explain ddl statements in pl/sql?
What are the disadvantages of file system?
