Select ename, eno, sal, rownum from (select ename, eno, sal from emp order

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / akshay

Answer Posted / akshay

Select ename, eno, sal, rownum
from (select ename, eno, sal from emp order by sal desc)
where rownum = 2;

Is This Answer Correct ?

7 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Why do we use procedures?

1007

Can one improve the performance of sql*loader? : aql loader

1099

How can we store rows in PL/SQL using array?

1270

What is difference between pls_integer and integer?

1011

Can we use pl sql in sql server?

1136

what is sql? : Sql dba

1071

What are the types of join in sql?

1149

Differentiate between sga and pga.

1208

What is pl sql commands?

1097

Which is better join or subquery?

1192

How do I debug a stored procedure?

1171

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1105

What is a sql statement?

1018

what are tables and fields? : Sql dba

1105

How are functions and procedures called in PL/SQL?

1309