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 are the different tcl commands in sql?

1106

Is sql developer case sensitive?

945

what is log shipping? : Sql dba

1059

What are the different types of sql commands?

1065

What is before trigger?

948

What is out parameter used for eventhough return statement can also be used in pl/sql?

1016

Why is partition used in sql?

1051

What does the sign mean in sql?

921

What are the types of records?

953

What is pl sql record in oracle?

971

Does truncate table reset auto increment?

941

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1158

What is range partitioning?

913

What is trigger with example?

1015

what is text? : Sql dba

1010