Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367884 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 / amy
select TOP salary from employee where salary in( select TOP 2 salary from employee order by salary desc) order by salary asc
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is an intersect?
How can I get the number of records affected by a stored procedure?
Can you skip header records while loading? : aql loader
Is primary key always clustered index?
What is basic structure of pl sql?
What are properties of the transaction?
What is a .db file?
Does sqlite need a server?
what are the limitations of identity column? : Transact sql
What trigger means?
how do you know if your mysql server is alive? : Sql dba
Is it mandatory for the primary key to be given a value when a new record is inserted?
How do I order columns in sql?
Can dml statements be used in pl/sql?
How to call shell script from pl sql procedure?
