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

Explain the difference between sap and oracle?

1029

if you ctreate table identity

2374

How to get a list of all background sessions in the database?

993

Explain oracle left join with an example?

1012

How to load a large xml file?

1055

What is the difference between count (*), count (expression), count (distinct expression)?

1005

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2555

Difference between varchar and varchar2 data types?

1184

what are the advantages of running a database in archive log mode?

2203

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4174

Explain a private synonyms?

1037

how to join query for one source type is oracle another source type is sql server ?

2425

How to load data from external tables to regular tables?

1062

What is Virtual Private Database in Oracle?

1090

How do you bind variables in oracle?

980