select ename,esal from (select ename,esal from hsal order by esal desc

how to find the second highest salary from emp table?

Question Posted / rameshwari

Answer Posted / rameshwari

select ename,esal from
(select ename,esal from hsal
order by esal desc)
where rownum <=2;

Is This Answer Correct ?

123 Yes

242 No

Please Help Members By Posting Answers For Below Questions

What is the difference between rename and alias?

1338

What are actual parameters and formal parameters?

1101

What is the difference between a primary key and a clustered index?

983

What normalization means?

968

What is nvarchar max in sql?

1010

Is it important to partition hard disk?

1022

Which version of sql do I have?

1050

what is csv? : Sql dba

993

What is keys and its types?

1069

How do I save a sql query?

1008

What is rtm in testing?

1103

How to add new employee details in an employee_details table with the following details

1086

What is pl sql quora?

1143

What is group function in sql?

1014

What is an exception in pl/sql?

1080