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 oracle used for?

986

What is the difference between "as" and "is" in an oracle stored procedure?

959

What is Java Pool in Oracle?

1110

What is the difference between postgresql and oracle?

997

How to convert numbers to characters in oracle?

988

What is an anonymous block?

1181

What to do if dba lost the system password?

1109

what is meant by magic query

2146

Where are the settings stored for each instance in oracle?

1076

How to use "in" parameter properly?

1018

What is a package ? What are the advantages of package ?

1049

How to invoke the data pump export utility?

1134

Can we write dml statement in function in oracle?

1042

Explain an exception and its types?

1033

How to define an oracle sub procedure?

1077