how to find the second highest salary from emp table?
- 211 Answers
- 320943 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 / ayush
select *
from (select ename,empno,salary,dense_rank()over(order by
salary desc) rank from emp)
where rank =2
| Is This Answer Correct ? | 19 Yes | 11 No |
Post New Answer View All Answers
Can we rename a column in the output of sql query?
how to install mysql? : Sql dba
Where is pl sql used?
What is sql*loader and what is it used for? : aql loader
How do you delete duplicates in sql query using rowid?
Can dml statements be used in pl/sql?
What is raw datatype in sql?
What is sqlca in powerbuilder?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What operators deal with null?
What is a ddl command?
Why do we need a foreign key?
Is sql port 1433 encrypted?
What is the command used to fetch first 5 characters of the string?
