Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367545 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 inner and outer join? Explain with example. : Sql dba
explain primary keys and auto increment fields in mysql : sql dba
what is top in tsql? : Transact sql
What is the difference between mdf and ndf files?
Is sql a oracle?
What jobs use sql?
What is difference between inner join and self join?
What is dba in sql? : SQL DBA
What is cursor and its types?
What is using in sql?
Can primary key be changed?
Explain autonomous transaction.
Can we create view in stored procedure?
What are character functions in sql?
How do you identify a primary key?
