select name, sal from (select name,sal from emp where sal<(select max(sa

how to calcuate the second highest salary of he employee

Question Posted / lalit

Answer Posted / lalit

select name, sal from (select name,sal from emp where sal<(select max(sal) from emp) order by sal desc)where rownum=1;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we use two order by clause in query?

1020

Does sql*plus have a pl/sql engine?

1136

How do I save a stored procedure?

1077

explain the difference between delete , truncate and drop commands? : Sql dba

1155

What is a call statement? Explain with an example.

1077

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7498

What is cartesian join in sql?

1199

What is pl sql architecture?

1008

Which one is better sql or oracle?

1015

What is pl sql collection?

1017

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1155

How do you clear the screen in sql?

1124

Mention what does the hierarchical profiler does?

1147

what is 'mysqlimport'? : Sql dba

1117

What is use of term?

1131