how to calcuate the second highest salary of he employee
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 temp table?
What is pl/sql language case sensitive?
What is delimiter sql?
Is primary key is clustered index?
What does select top 1 do in sql?
define sql insert statement ? : Sql dba
Can we change the table name in sql?
What is over () in sql?
What are the various levels of constraints?
Does oracle roll back the transaction on an error?
What is database white box testing and black box testing?
What is vector point function?
What is sqlcommand?
Why use triggers in sql?
What are the different sql commands?