SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN(SELECT MAX(SALARY) FR

how to select second mauximum value in a given table under salary column

Question Posted / jai

Answer Posted / jai

SELECT MAX(SALARY) FROM EMPLOYEE
WHERE SALARY NOT IN(SELECT MAX(SALARY) FROM EMPLOYEE)

Is This Answer Correct ?

27 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2154

What is format trigger?

2077

Hi Can any one tell me what are the API's used in requisition import.

1928

How to update values in a table in oracle?

1030

Explain the types of exception?

1149

How can windows applications connect to oracle servers?

1064

Briefly explain what is literal? Give an example where it can be used?

1049

How do I uninstall oracle client from windows?

1018

What is a sub query? What are its various types?

1188

What is a private synonym?

1593

interview questions with answer for cts

2594

what is the dual table in oracle?

1003

What is a schema in oracle?

1026

How to convert character types to numeric types?

1141

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

1101