select max(salary)from employees where salary

How to Remove the 3rd highest salary person record from
table?

Question Posted / avnish srivastava-test engg fc

Answer Posted / avnish srivastava-test engg fc

select max(salary)from employees
where
salary < (select max(salary)from employees where
salary < (select max(salary) from employees))

Is This Answer Correct ?

10 Yes

11 No

Please Help Members By Posting Answers For Below Questions

Is there a function to split a string in plsql?

1109

What are the uses of synonyms?

1184

Describe varray?

1116

How to manage transaction isolation level?

1054

What is the implicit cursor in oracle?

1169

How to add a new column to an existing table with a default value?

1056

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

1092

How to compare dates in oracle sql?

1159

What happens if the update subquery returns multiple rows?

1167

Explain an exception and its types?

1134

what is normalisation?what are its uses?

2328

How to insert a new row into a table in oracle?

1215

Explain the features of oracle?

1107

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2396

Explain the function of optimizer in oracle?

1197