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 do I find my oracle client driver version?

1032

What are the extensions used by oracle reports?

1031

Explain the use of owner option in exp command.

1037

What are the different types of trigger and explain its various uses and functions?

1082

How to set a transaction to be read only in oracle?

1089

How to create an oracle database?

1029

what is port in oracle? how is it related to database application.

1939

What are the data types in oracle?

1032

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1892

What are dml statements in oracle?

1088

How to start a specific oracle instance?

1029

What is the relation of a user account and a schema?

1124

What the is the diff between local index and global index. give some example.

1630

Difference between pre-select and pre-query

1097

What privilege is needed for a user to create indexes in oracle?

1018