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

What are temporal data types in oracle?

1164

How do we display rows from the table without duplicates?

1014

How do I know if oracle client is installed on windows?

1090

How to pass parameters to procedures?

1085

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

1173

What is oracle thin client?

1076

What is the difference between substr & instr functions?

1292

What is a data lock in oracle?

1178

What is the difference between truncate & delete command?

1233

What is oracle datasource?

1037

How to create a new tablespace in oracle?

1030

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2089

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1065

Can objects of the same schema reside in different tablespace?

1101

Can you have more than one content canvas view attached with a window ?

2368