how to find the second highest salary from emp table?
- 211 Answers
- 322210 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 / sachin verma
select sal from emp
where rownum=2
order sal by Desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is embedded sql with example?
What are keys in sql?
What is Histogram?
Which tcp/ip port does sql server run?
What is the difference between a primary key and a clustered index?
What is error ora-01000: maximum open cursors exceeded
How to add, remove, modify users using sql?
What is program debugging?
Explain table and field in sql?
what is meant by urlencode and urldocode? : Sql dba
Can we use the cursor's to create the collection in PL/SQL?
Why are indexes and views important to an organization?
How many types of functions are there in sql?
What is the use of non clustered index?
What are the sql aggregate functions?
