select salary from employees order by salary desc offset 2 rows fetch n

find out the third highest salary?

Question Posted / daji surwase

Answer Posted / daji surwase

select salary
from employees
order by salary desc
offset 2 rows fetch next 1 row only;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a dynamic performance view in oracle?

989

What is the difference between I and G in Oracle?

1097

When do we use group by clause in a sql query?

1035

Is java required for oracle client?

996

Explain parameter file in oracle.

1027

What does sharding mean?

997

Difference between inner join vs where ?

1033

Can we write dml statement in function in oracle?

1081

Explain the use of show option in imp command.

1096

Explain the use of control file?

1111

Which is better Oracle or MS SQL? Why?

6386

What are the differences between primary key and unique key?

1008

What is a cognitive schema?

960

How many types of database triggers exist?

1128

What are the extensions used by oracle reports?

1036