select * salary from table < select max(salary) from table order by sal

How to Select second Maximum salary in a Table ?

Question Posted / 9896012055

Answer Posted / 9896012055

select * salary from table < select max(salary) from table
order by salary;

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

how can we store any pdf file in oracle

2096

How to synchronize 2 schema's objects?

2117

How to use "for" statements in oracle?

1019

How to convert numbers to characters in oracle?

971

How to list all indexes in your schema?

1033

What is the use of file param in imp command?

1117

What is sharded cluster?

926

How to create a new table by selecting rows from another table?

1019

How to use values from other tables in update statements using oracle?

1026

What is Data Dictionary Cache in Oracle?

1119

What is a cursor variable?

1047

Explain oracle data types with examples?

969

What is a system tablespace?

1008

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2065

List out the components of logical database structure of oracle database.

986