Interested to Buy Any Domain ? << Click Here >> for more details...
how to calcuate the second highest salary of he employee
- 13 Answers
- 18080 Views
- Synechron, I also Faced
- E-Mail Answers
Answer Posted / vinayak jamdar
Select top 1 empid,salary from (select distinct top 2
empid,salary from emp order by salary desc)a order by salary
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How sql query is executed?
Why is there a need for sqlcode and sqlerrm variables?
Is and as keyword in pl sql?
What is data abstraction in sql?
What are the ddl commands?
How do you concatenate in sql?
What is the difference between a subquery and a join?
What do you understand by case manipulation functions?
How is indexing done in search engines?
Explain the difference between triggers and constraints?
What are variables in pl sql?
What is difference between table and view?
Is left join and outer join same?
What is sql server and ase?
What is the use of pl/sql table?
