select salary from (select salary from emp order by salary desc) where ro

how to calcuate the second highest salary of he employee

Question Posted / udhayakumar

Answer Posted / udhayakumar

select salary from (select salary from emp order by salary
desc) where rownum=2;

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can you load data into multiple tables at once? : aql loader

1075

How do I filter in sql profiler?

1002

Does access use sql?

1047

what is heap table? : Sql dba

1109

Is microsoft sql free?

1107

how to analyze tables with 'mysqlcheck'? : Sql dba

1016

What is duration in sql profiler trace?

1085

Why do we need a foreign key?

1104

How do I make sql search faster?

1003

How do I view a procedure in sql?

978

What is character functions?

1066

what does the t-sql command ident_incr does? : Transact sql

1083

what are the differences between char and varchar? : Sql dba

1077

What is the purpose of a sql?

978

What is sql rowcount?

1033