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
What is numeric function sql?
What is the most common sql injection tool?
What is the difference between delete and truncate commands?
How do you update a table in sql?
Is left join and outer join same?
What is the most restrictive isolation level? : Transact sql
What is before trigger?
what are the advantages of sql ? : Sql dba
Enlist the advantages of sql.
What are some predefined exceptions in pl/sql?
Explain what is an index?
What is form and report?
How does a trigger work?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Is clustered index a primary key?