select max(salary) as second_highest from emp where salary

how to find the second highest salary from emp table?

Question Posted / karthik.k

Answer Posted / karthik.k

select max(salary) as second_highest from emp where salary
< (select max(salary) from emp)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is pl sql code?

995

What is audit logout in sql profiler?

979

What is a rank in sql?

901

What is clustered index in sql?

1003

How can a pl sql block be executed?

891

What is an inner join sql?

956

Can we join tables without foreign key?

909

How can we avoid duplicating records in a query?

925

what is single byte over head in oracle..?

2342

What is the limitation on the block size of pl/sql?

938

What is sql resultset?

934

How do I start sql profiler?

943

What is the syntax and use of the coalesce function?

1100

What is query execution plan in sql?

1130

What are the two characteristics of a primary key?

927