how to find the second highest salary from emp table?
Answer Posted / krishna kishore
select top 1 salary from emp where salary in
(select top 2 salary from emp order by salary desc)
order by salary
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain what is a field in a database and record in a database?
Which command is used to delete a package?
How much does a sql dba make? : SQL DBA
What are functions in sql?
How many types of keys are there in sql?
Can we use view in stored procedure?
What is mutating sql table?
Can you join views in sql?
what is the difference between delete and truncate commands? : Sql dba
Is sql a microsoft product?
What is procedure explain with example?
what is the difference between cluster and non cluster index? : Sql dba
What is the difference between having and a where in sql?
how to shutdown mysql server? : Sql dba
What is difference between primary and secondary key?