select a.sal,rank from(select sal,rank() over (order by sal desc))a where

how to find the second highest salary from emp table?

Question Posted / praveen kumar.dandu

211 Answers
373209 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 / praveen kumar.dandu

select a.sal,rank from(select sal,rank() over (order by sal
desc))a where rank=&n

<Here after printing the ranks we can retrieve we can
retreive what ever the rank we want>

Is This Answer Correct ?

2 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the two types of periodical indexes?

987

What is a dirty read sql?

1247

how to use like conditions? : Sql dba

1166

how to get @@error and @@rowcount at the same time? : Sql dba

1082

Can primary key be changed?

955

What is difference between pl and sql?

1111

What is a sql statement?

1019

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1116

What is having clause in sql?

1018

Can a commit statement be executed as part of a trigger?

1105

what is the command used to fetch first 5 characters of the string? : Sql dba

1684

Why cross join is used?

1139

What are the sql aggregate functions?

1184

What is database sql?

1099

How many triggers can be applied on a table?

989