select Income from ( select Rank() over(order by Income desc) topRecord,

how to find the second highest salary from emp table?

Question Posted / barochia dharmesh

211 Answers
372945 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

How do you rename a table in sql?

1183

Is primary key is clustered index?

1039

What are the benefits of stored procedures?

1126

Is merge a dml statement?

1029

What are sql queries used for?

1072

What is data control language (dcl)?

1202

How do you modify a column in sql?

1047

What is normalisation and its types?

1043

What are tables and fields in the database?

1184

what is the syntax used for partition in tsql? : Transact sql

1058

explain mysql aggregate functions. : Sql dba

1028

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1222

What is delimiter sql?

1058

How do I run a program in pl sql?

1053

How can I change database name in sql?

1156