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

What is the parameter mode that can be passed to a procedure?

1055

what is the use of system.effective.date variable in oracle?

1121

What is the use of file param in imp command?

1165

Explain integrity constraints?

1109

How to drop a stored function?

1140

How to export data with a field delimiter?

1045

How to use attributes of the implicit cursor in oracle?

1011

Is a rollback possible to any savepoint?

1102

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2106

How can I get column names from a table in oracle?

1052

List out the difference between commit, rollback, and savepoint?

1039

How to revoke create session privilege from a user in oracle?

1020

List out the types of joins.

1164

What is Redo Log Buffer in Oracle?

1212

What are named parameters?

1097