Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368271 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 / hemant
select salary,empname from employee where
salary=(select max(salary) from employee where
salary<(select max(salary) from employee))
This query will produce all the result whose salary is
second highest.
1. A 20000
2. B 20000
3. C 20000
4. D 20000
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is a table valued function object?
How do I use google cloud in sql?
Can dml statements be used in pl/sql?
What is embedded sql what are its advantages?
What is the purpose of my sql?
How to download oracle sql developer?
How do I remove all records from a table?
Why self join is used in sql?
What is varchar sql?
What is sqlservr exe?
what is timestamp in mysql? : Sql dba
What are triggers and its types?
Does execute immediate commit?
What are the types of optimization?
Why function is used in sql?
