Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361456 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 / hitesh
select top 1 salary from t1 where salary in(select top 2
salary from t1 order by salary desc)order by salary asc
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What are the uses of merge?
Is sqlite thread safe?
What does bitemporal mean?
What are the properties of a transaction?
What is rownum in sql?
What is data type in database?
Advantages and disadvantages of stored procedure?
How to order siblings in oracle hierarchy queries?
What is mutating error in pl sql?
Can we use ddl commands in pl sql?
Enlist the advantages of sql.
how to select first 5 records from a table? : Sql dba
What is the use of desc in sql?
Which is the correct statement about truncate and delete?
Why we use stored procedure instead of query?
