select max(sal)from table;

How to Select second Maximum salary in a Table ?

Question Posted / a.swarna devi

13 Answers
15363 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / a.swarna devi

select max(sal)from table;

Is This Answer Correct ?

2 Yes

13 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the oracle implicit cursor?

1019

Why do we use coalesce function in oracle?

1071

Explain an extent?

1056

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2913

What are the advantages of oracle 12c?

1135

In what script is snap$ created? In what script is the scott/tiger schema created?

2670

How to define a record variable to store a table row?

1025

query optmization techniques and quwry analyser+projects+ppts

2382

What do you know about normalization? Explain in detail?

896

what is the difference between functional dependecy and multilevel dependency?

2429

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2219

What is backup in Oracle?

966

Explain the use of constraints option in exp command.

1007

Explain rename?

934

What is the data type of dual table?

935