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 to use case expression? : Sql dba

1028

explain about mysql and its features. : Sql dba

1016

The select into statement is most often used to create backup copies of tables or for archiving records?

1065

How many joins can you have in sql?

938

What are the two types of cursors in pl sql?

1082

How do you break a loop in pl sql?

1050

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1002

What is the use of & in pl sql?

1046

What is package in pl sql with an examples?

1036

What is a join?

1069

how many groups of data types? : Sql dba

1027

Are left and right joins the same?

1088

What is the difference between truncate and drop statements?

1190

which operator is used in query for pattern matching? : Sql dba

1007

How bulk collect improves performance?

1006