select max(salary)from employees where salary

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

Question Posted / jainish

Answer Posted / jainish

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

Is This Answer Correct ?

4 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How to commit the current transaction in oracle?

1179

How to define a sub function?

1199

How translate command is different from replace?

1140

How to execute the package in oracle?

1135

How to create a server parameter file?

1186

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2116

What is an oracle?

1064

What is Reduced List of Values?

2244

How to retrieve values from data fields in record variables?

1171

What is a package in oracle?

1160

How to get the Installed Oracle Version Information ?

1188

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2310

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

1102

What happens to the current transaction if the session is killed?

1034

Give syntax for SQL and ORACLE joins.

1144