select *from(select *from emp orderby sal desc)where ronum<=2 minus se

how to find the second highest salary from emp table?

Question Posted / vinodkumar

Answer Posted / vinodkumar

select *from(select *from emp orderby sal desc)where
ronum<=2 minus select *from (select *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

How to take user input in pl sql?

1167

what is oracle database ? : Sql dba

1035

What is native sql query?

1026

What is the purpose of the sql select top clause?

1116

How do I start pl sql?

953

What is trigger in sql and its types?

1065

What are different types of functions in sql?

1006

What is bind variable in pl sql?

1057

How many commands are there in sql?

1032

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

980

What do you mean by “trigger” in sql?

1085

Does inner join remove duplicates?

945

What is oracle sql developer?

1062

What is mdf ldf and ndf?

1002

How would you pass hints to the sql processor?

983