select max(salary) from users where salary not in (select max(salary) from

find out the second highest salary?

Question Posted / new

Answer Posted / new

select max(salary) from users where salary not in (select max(salary) from users)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How is it different from a normal table?

1084

What is a nested table?

1111

Does oracle partitioning improve performance?

1052

When do you get a .pll extension in oracle?

1192

How to sort output in descending order in oracle?

1103

Explain a data segment?

1112

Is oracle an open source?

1127

How to convert characters to times in oracle?

1070

How to omit columns with default values in insert statement in oracle?

1099

how to make an oracle object

2395

How to delete a column in an existing table in oracle?

1127

How do I uninstall oracle 11g?

1177

Explain the truncate in oracle?

1012

Explain the use of ignore option in imp command.

1086

What is Reduced List of Values?

2244