select max(sal) from emp where rownum = 2;

how to find the second highest salary from emp table?

Question Posted / vinay

Answer Posted / vinay

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is foreign key sql?

985

What is type and rowtype in pl sql?

1016

How to order siblings in oracle hierarchy queries?

1047

Explain about various levels of constraint.

949

What is example of database?

1056

What are the three forms of normalization?

1045

What is nosql db?

970

Can a table have no primary key?

1062

How does one use sql*loader to load images, sound clips and documents? : aql loader

1187

What is sql procedures and functions?

1005

what are the t string functions available in tsql? : Transact sql

1008

What are triggers and its types?

1062

How do I turn a list into a table?

961

how to delete an existing column in a table? : Sql dba

1005

What is partition by in sql?

1068