how to find the second highest salary from emp table?
- 211 Answers
- 322265 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 / yash goyal
Select Distinct salary
from employees e
where &no-1=(select count(distinct salary )
from employees
where E.salary < salary);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is mariadb nosql?
How do I make sql search faster?
What is parallel hint?
What are the possible values that can be stored in a boolean data field?
What are the basic techniques of indexing?
What are different joins used in sql?
What is the use of non clustered index?
What are the features of pl sql?
What port does sql server use?
what are the different type of sql's statements ? : Sql dba
What is sql deadlock?
What is difference between mysql and postgresql?
How do I view a procedure in sql?
What's the difference between inner join and left join?
How do I start pl sql?
