select sal from (select distinct(sal) from emp where sal is NOT NULL order

how to find the second highest salary from emp table?

Question Posted / sumit sharma

Answer Posted / sumit sharma

select sal from (select distinct(sal) from emp where sal is
NOT NULL order by sal dsc) where rownum = 2

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is function and procedure in pl sql?

975

Explain the difference in execution of triggers and stored procedures?

969

What is procedure explain with program?

952

Can we have two clustered index on a table?

968

What is a parameter query?

1023

What is parallel hint?

1223

How do you use join?

890

What is the basic form of sql query?

881

what is sub-query? : Transact sql

1041

Why primary key is required?

939

How do I view an execution plan in sql?

924

What is using in sql?

1019

What is the use of double ampersand (&&) in sql queries? Give an example

1082

Explain scalar functions in sql?

1019

what is log shipping? : Sql dba

1058