Interested to Buy Any Domain ? << Click Here >> for more details...
how to calcuate the second highest salary of he employee
- 13 Answers
- 18979 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
What is a parameter query?
Which join is default?
What are triggers and its types?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is percent sign in sql?
How to make a copy values from one column to another in sql?
Can I create table without primary key?
How to get help at the sql prompt?
Explain about various levels of constraint.
Can we call procedure in select statement?
What is meant by <> in sql?
What is crud diagram?
Define join and name different types of joins?
Can a foreign key have a different name?
What is memory optimized?
