this is the best way to find out thethird highest salary from emp table

find out the third highest salary?

Question Posted / deepal saini

92 Answers
150708 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

Answer Posted / deepal saini

this is the best way to find out thethird highest salary from emp table

select max(sal) from emp where sal<(select max(sal) from emp where sal <(select max(sal)from emp));

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to connect to a local oracle 10g xe server?

992

Explain what are the type of synonyms?

1109

What is recycle bin in Oracle?

1147

What is oracle database 10g express edition?

1118

Can we write dml statement in function in oracle?

1081

what is Single Byte Overhead...?

2553

How to declare a local variable?

1110

How to pass parameters to procedures?

1030

Explain the features of oracle?

1038

Explain the use of tables option in exp command.

1115

How to omit columns with default values in insert statement in oracle?

1044

What is columnar storage what is the advantage?

1059

How can I get column names from a table in oracle?

1048

How to convert times to characters in oracle?

1026

List the various oracle database objects?

1055