select max(salary) from emptable where salary

Write query to fetch second maximum salary from employee table.

Question Posted / ritesh

Answer Posted / ritesh

select max(salary) from emptable where salary < (select max(salary) from emptable);

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can we view last record added to a table?

784

How would you change old and new values in an insert, delete and update triggers?

749

Explain the use of online redo log files in oracle.

760

What is a trigger and what are its types?

777

What is parameterized cursor in oracle?

788

How to export your own schema?

738

What is meant by joins?

814

How to invoke the data pump import utility?

807

How to add a new column to an existing table in oracle?

824

What is Data Dictionary Cache in Oracle?

880

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

1941

What is query image?

730

How to bring a tablespace offline?

718

How to connect to the server with user account: sys?

754

How to store only time; not date and time?

715