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 is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

979

Explain integrity constraints?

1107

Please explain oracle left join with an example?

1048

Name the various constraints used in oracle?

1020

what is the difference between substr and instr function in oracle?

1090

How to use "startup" command to start default instance?

1036

What are the parameters that we can pass through a stored procedure?

1065

Why is oracle used?

939

Is primary key indexed by default in oracle?

987

Explain the importance of .pll extension in oracle?

1012

What happens to indexes if you drop a table?

1171

What are the uses of Database Trigger ?

1720

How to bring a tablespace offline?

1065

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

1095

How many types of database triggers exist?

1135