select Max(sal) from emp This will give us 1highest sal Select Max (s

find out the third highest salary?

Question Posted / prithvi

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

Answer Posted / prithvi

select Max(sal) from emp

This will give us 1highest sal

Select Max (sal) from where sal <(select Max(sal) from emp)

Select Max (sal) from where sal <(Select Max (sal) from
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

What is the maximum number of triggers that can be applied to a single table?

1029

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1663

How do we represent comments in oracle?

1057

How to select all columns of all rows from a table in oracle?

1055

What happens if you lost a data file?

1037

How to start an oracle instance?

1025

1) Does oracle have any table which contain all the exceptions and it's code internally?

1754

How a database is related to tablespaces?

1039

is there a tool to trace queries, like profiler for sql server?

1145

How to use in conditions in oracle?

1058

Difference between oracle's plus (+) notation and ansi join notation?

1111

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1384

How to convert characters to dates in oracle?

1104

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2356

Respected sir, Please send me technical questions related to oracle apps..

1815