how to find the second highest salary from emp table?
- 211 Answers
- 322088 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / ashwini
select top 1 salary from emp where salary in (select top 2
salary from emp order by salary asc) order by salary desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is left inner join in sql?
What is data manipulation language?
What are the three pl sql block types?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
what is auto increment? : Sql dba
What is an escape character in sql?
How do you go back in sql?
What is pl/sql language case sensitive?
How do I delete a trigger?
what is recursive stored procedure? : Sql dba
How do I find duplicates in a single column in sql?
What is microsoft t sql?
What is pl sql and why it is used for?
How do I find duplicates in the same column?
