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

How do I trace sql profiler?

958

What is the order of sql select?

1035

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1428

Define commit, rollback and savepoint?

1017

State few characteristics of pl/sql?

968

Is postgresql a server?

1034

how to convert character strings to dates? : Sql dba

1041

What is $$ in sql?

976

explain advantages of innodb over myisam. : Sql dba

1115

explain primary keys and auto increment fields in mysql : sql dba

953

What is dba in sql? : SQL DBA

1029

What is pl sql record in oracle?

1015

what is msql? : Sql dba

971

How to run sql functions in pl/sql?

1042

What is the usage of distinct keyword?

1051