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

What is an implicit commit?

1103

what is auto increment? : Sql dba

1052

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2063

What is pl/sql table? Why is it used?

1095

What is primary key secondary key alternate key candidate key?

1088

What is the maximum size of sqlite database?

1156

What does joining a thread mean?

1078

What are schema-level triggers?

1155

What is substitution variable in pl sql?

1114

Why do we need cursors in pl sql?

1160

Can you have a foreign key without a primary key?

1000

what is schema? : Sql dba

1113

Is a table valued function object?

1076

Which join condition can be specified using on clause?

1015

how to check myisam tables for errors? : Sql dba

1397