how to find the second highest salary from emp table?
- 211 Answers
- 321391 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
Please Help Members By Posting Answers For Below Questions
What is raw datatype in sql?
Is sql a scripting language?
What do you mean by query optimization?
What is the current version of postgresql?
Does normalization improve performance?
What is snowflake sql?
How is data stored in sql?
How many sectors are in a partition?
Why truncate is used in sql?
Why is sql important?
What is orm in sql?
What mean sql?
What is the purpose of my sql?
What is an alias command?
What is sqlerrd?
