select max(sal)from table;

How to Select second Maximum salary in a Table ?

Question Posted / a.swarna devi

13 Answers
15229 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

When do you get a .pll extension in oracle?

1078

What is a system tablespace?

1008

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2248

How to select some rows from a table in oracle?

1007

How to drop an existing table in oracle?

1015

What is meant by joins? List out the types of joins.

960

What is an oracle?

958

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1814

What is where clause in oracle?

982

Can we connect to ORACLE db using Windows Authentication?

1183

Is oracle an open source?

1021

Point out the difference between user tables and data dictionary?

932

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?

2203

Why we use bulk collect in oracle?

973

how to make an oracle object

2292