select min(empsal) from (select * from sal order by empsal desc) where

how to find the second highest salary from emp table?

Question Posted / abir dutta

211 Answers
373081 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 / abir dutta

select min(empsal)
from (select * from sal order by empsal desc)
where rownum <=2

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is it possible to sort a column using a column alias?

1100

What are the ddl commands?

1055

What is the difference between count 1 and count (*) in a sql query?

1054

What is benefit of creating memory optimized table?

1032

How to find 3rd highest salary of an employee from the employee table in sql?

1133

What is nvarchar in sql?

978

What is the sql query to display the current date?

1092

What is difference between rank () row_number () and dense_rank () in sql?

1160

How to take user input in pl sql?

1204

What is a null value?

1191

What is sql basics?

1083

Is pl sql useful?

1037

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2067

what is a database transaction? : Sql dba

1258

How does sql profiler work?

1065