how to find the second highest salary from emp table?
- 211 Answers
- 322094 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 / jhansi
select max(sal) from emp where sal<any(select max(sal) from
emp)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What is a full join sql?
What are the benefits of pl/sql packages?
What are system versioned tables?
What are inner and outer joins examples of both?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What are records give examples?
What is clause?
How do I view a sql database?
What is sqlservr exe?
Why do we use function in pl sql?
What is rank function in sql?
How do I view tables in mysql?
What are the types of subqueries?
What are all ddl commands?
what is single byte over head in oracle..?
