select * from (select rownum r,a.* from (select distinct sal from emp ord

how to find the second highest salary from emp table?

Question Posted / prasanthi

Answer Posted / prasanthi

select * from (select rownum r,a.* from (select distinct
sal from emp order by sal desc)a)where r=&i

sql>enter i value(enter manually) 2

Is This Answer Correct ?

54 Yes

62 No

Please Help Members By Posting Answers For Below Questions

How can we store rows in PL/SQL using array?

1162

What is dba in sql? : SQL DBA

999

How do you declare a user-defined exception?

965

What is duration in sql profiler trace?

1022

How do you write an index?

915

what is the difference between union and union all? : Sql dba

976

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

946

what happens if null values are involved in expressions? : Sql dba

1001

How do I start sql from command line?

964

Can we perform dml on view?

976

What are the basic techniques of indexing?

1014

What is trigger types of trigger?

996

Can we use joins in subquery?

1089

what is data control language? : Sql dba

959

what is oracle database ? : Sql dba

972