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 are the two characteristics of a primary key?

927

How many tables can a sql database have?

927

What is clustered index in sql?

1003

What is mutating sql table?

1041

What is indexing oracle sql?

1026

What is the starting oracle error number? What is meant by forward declaration in functions?

940

How do you identify a primary key?

1013

How to sort the rows in sql.

1011

Is sql port 1433 encrypted?

974

Can %notfound return null after a fetch?

1005

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

994

What are the packages in pl sql?

968

What is cursor in pl sql?

1052

What is memory optimized?

1011

What is tuple in sql?

1008