select sal from emp where rownum=2 order by sal desc

how to find the second highest salary from emp table?

Question Posted / pradeep

Answer Posted / pradeep

select sal from emp
where rownum=2
order by sal desc

Is This Answer Correct ?

10 Yes

50 No

Please Help Members By Posting Answers For Below Questions

What are database links used for?

1095

In pl/sql, what is bulk binding, and when/how would it help performance?

1032

How much does sql cost?

1067

How many sql statements are used?

1070

How is data stored on a disk?

1082

What is embedded sql what are its advantages?

1108

What does the base_object_type column shows in the user.triggers data dictionary view?

1096

Does oracle roll back the transaction on an error?

1067

What is %type in pl sql?

1008

How can the performance of a trigger be improved?

1087

Explain how can you save or place your msg in a table?

1074

What is crud diagram?

993

What's the difference between a primary key and a clustered index?

1024

explain the difference between delete , truncate and drop commands? : Sql dba

1146

How does sql developer connect to oracle database?

1051