how to find the second highest salary from emp table?
- 211 Answers
- 322074 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 / dakshin
select * from (select a.*,dense_rank() over (order by sal) rnk from emp a order by sal) where rnk =2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql lookup?
Why do we use %rowtype & %type in plsql?
What are the sql aggregate functions?
What is synchronized subquery?
What is a pragma statement?
What are the different types of dbms?
what are integrity rules?
give the syntax of grant and revoke commands? : Sql dba
What is the difference between an inner join and an outer join?
what is self-join? : Sql dba
What is sql in java?
What is function and procedure?
Why truncate is faster than delete?
how to create a table index in mysql? : Sql dba
What are the different dml commands in sql?
