how to find the second highest salary from emp table?
- 211 Answers
- 322598 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 / barochia dharmesh
select Income from (
select Rank() over(order by Income desc) topRecord, Income
from (select distinct Income from tblName) tbl ) tbl2
where topRecord = 2
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why do we use procedures?
Is sql injection illegal?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is sql entity?
Which sql statement is used to delete data from a database?
Define concurrency control. : Transact sql
What are the usages of sql?
How does one load ebcdic data? : aql loader
What is the difference between a procedure and a function?
What is self-join and what is the requirement of self-join?
what are wild cards used in database for pattern matching ? : Sql dba
What is an exception in PL/SQL? What are the two types of exceptions?
what is the functionality of the function htmlentities? : Sql dba
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is difference between inner join and cross join?
