SQL> select emp_sal from (select emp_sal from nitin order by emp

how to find the second highest salary from emp table?

Question Posted / nitin

Answer Posted / nitin

SQL> select emp_sal from (select emp_sal from nitin order
by emp_sal desc) group by rownum,emp_sal
having rownum=2;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what is an index?

1054

How can I get the number of records affected by a stored procedure?

1061

What types of commands can be executed in sql*plus?

1109

What is bind reference and how can it be created?

1017

What is raid? How does it help storage of databases?

1083

What is the basic form of sql query?

942

How do I run a sql trace?

957

Is join and inner join the same?

1002

Is pl sql different from sql?

994

Is left join inner or outer by default?

1019

What is anonymous block in sql?

1120

what is a record in a database ? : Sql dba

1061

What is pl sql and why it is used for?

1113

What is break?

1197

How many sql commands are there?

1114